Importing CSV Data did not bring in data related to time correctly

[Former Member]

I tried to bring in CSV data using Data/Import. All columns came in except for the time related data. Some details are here: http://hodentekmsss.blogspot.com/2017/01/importing-csv-file-into-sapss-sql.html

[johnsmirnios]

You chose a datatype of 'time' which only stores hour, minute, second and fraction of a second; however, the data contains dates & times where all of the times were 00:00:00 which is 12:00 am as seen in the table after the load. That looks correct to me. If you want a date and time, use a TIMESTAMP.

[Former Member]

Thank you. Microsoft does not have datastamp. I will do it again. I had a hunch that this may be the reason.

[Former Member]

Yes. Timestamp is the correct data type to use. Thanks

[Breck_Carter]

> Microsoft does not have datastamp

Microsoft SQL Server does have the datetime data type which is more-or-less the same as SQL Anywhere's timestamp.