on 2021 Aug 19 3:34 AM
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As to the century, please also check the nearest century option. It decides how 'yy' is mapped to 'yyyy', so to speak.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.