Date\Time

[neoklis]

Hi,

In an Access table i have a field type date/time. The format for the field is "00:00". I am trying to import that table in Sql but with no luck. I found out that the problem is related to the field type i mentioned before. What is the correct data type for Sql;

Thanks

 

[tehNellie]

datetime or smalldatetime, SQL server won't store just a date or just a time though.

If you insert just a date into the field you'll end up with yyyy-mm-dd 00:00:00

If you insert just a time into the field you'll end up with 1900-01-01 hh:mm:ss
(on smalldatetime field, datetime stores to thousandths of a second).

Smallest amount of information you can insert is a year [2000] or hh:mm on a time.