General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Y2k problem when importing data
I have a delimited ascii file that I am importing via the import wizard. The data has dates in the format 01/01/00 which I
wish to represent as Jan 1, 2000. After the import, if I "set century on" the years all show as 1900 instead of 2000. What
can I do to import this correctly?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only