Import/Export wizard DateTime problem

[Piero 'Giops' Giorgi]

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

[Erland Sommarskog]

Re: Import/Export wizard DateTime problem

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

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@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Piero 'Giops' Giorgi]

Re: Import/Export wizard DateTime problem

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

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

Thank you!

P