cancel
Showing results for 
Search instead for 
Did you mean: 

Adding the number 19 to the date

0 Kudos
1,141

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

Accepted Solutions (0)

Answers (2)

Answers (2)

johnsmirnios
Employee
Employee

See http://dcx.sybase.com/index.html#sqla170/en/html/813a963e6ce210149d1ebbd44cf13f64.html*loio813a963e6...

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"

VolkerBarth
Contributor
0 Kudos

April instead of March, I assume.

johnsmirnios
Employee
Employee
0 Kudos

Thank you, yes. It was early. I have edited my post.

VolkerBarth
Contributor
0 Kudos

As to the century, please also check the nearest century option. It decides how 'yy' is mapped to 'yyyy', so to speak.