The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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

asked 24 Mar, 18:02

mysorian's gravatar image

mysorian
1186613
accept rate: 0%


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.

permanent link

answered 24 Mar, 21:07

John%20Smirnios's gravatar image

John Smirnios
8.9k377112
accept rate: 39%

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

(24 Mar, 23:37) mysorian
Replies hidden

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

(25 Mar, 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, 08:09) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×242
×4

question asked: 24 Mar, 18:02

question was seen: 152 times

last updated: 26 Mar, 12:47