when I import the csv file to a sql anywhere database, a field of type datetime has a problem. example : the date of the imported csv file 17-04-21 (dd-mm-yy) in the sql anywhere database becomes the date 1917-04-21. There is an addition of 19 to 17. Does anyone know why? Johanes |
When dates are ambiguous, the "DATE_ORDER" option controls how they are interpreted. "17-04-21" might be "April 21, 2017" or "April 17, 2021" April instead of March, I assume.
(19 Aug '21, 08:30)
Volker Barth
Replies hidden
Thank you, yes. It was early. I have edited my post.
(19 Aug '21, 08:47)
John Smirnios
|
As to the century, please also check the nearest century option. It decides how 'yy' is mapped to 'yyyy', so to speak. |