Rank: Newbie
Groups: Registered
Joined: 3/19/2018(UTC) Posts: 2  Location: Havlickuv Brod
|
I am reading data from CSV file (Timestamp(date), Value (float)). Connection is fine. I can see corect data in table and also chart is fine. I have problem when I try create restriction on date (date between 'somedate1' and 'somedate2'). I receive error message "ERROR [22018] [Microsoft][ODBC text Driver] Data type mismatch in criteria expression". Column Timestamp is set to date format in ODBC.
Knows anybody solution please. Thanks
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 596  Thanks: 9 times Was thanked: 86 time(s) in 83 post(s)
|
this is related to the ODBC Text driver, I do not know if it supports the date time restrictions. Perhaps the SQL generated must have a special format for datetime.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/19/2018(UTC) Posts: 2  Location: Havlickuv Brod
|
Thank you for ansver. I used construction "where (day(F2) between day('@Date1') and day('@Date2')) and (month(F2) between month('@Date1') and month('@Date2')) and (year(F2) between year('@Date1') and year('@Date2'))". I dont know if it is the best solution but works.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.