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 |
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. Thank you. Microsoft does not have datastamp. I will do it again. I had a hunch that this may be the reason.
(24 Mar '17, 23:37)
mysorian
Replies hidden
Yes. Timestamp is the correct data type to use. Thanks
(25 Mar '17, 20:40)
mysorian
1
> 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.
(26 Mar '17, 08:09)
Breck Carter
|