Import/Export wizard DateTime problem

Hi, all!

The Criminal DB is going strong (as of today: 50 Tables, on 3077
Filegroups)

Right now I stuffed in it about 2 million records (About 7% of total),
but I'm constantly having an issue with dates.

What is the CORRECT format to use when importing a DateTime Field???

Thank you!!!

Piero

Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:

Quote:

The Criminal DB is going strong (as of today: 50 Tables, on 3077
Filegroups)
>
Right now I stuffed in it about 2 million records (About 7% of total),
but I'm constantly having an issue with dates.
>
What is the CORRECT format to use when importing a DateTime Field???

The ultimate guide to date formats on SQL Server:
http://www.karaszi.com/SQLServer/info_datetime.asp

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Jul 6, 2:43 pm, Erland Sommarskog <esq...@sommarskog.sewrote:

Quote:

The ultimate guide to date formats on SQL Server:http://www.karaszi.com/SQLServer/info_datetime.asp

Thank you!

P

Import/Export wizard DateTime problem

re: Import/Export wizard DateTime problem

re: Import/Export wizard DateTime problem

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about