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

Re: Import/Export wizard DateTime problem

Piero 'Giops' Giorgi (giorgi.piero@gmail.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@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Import/Export wizard DateTime problem

On Jul 6, 2:43 pm, Erland Sommarskog wrote:

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

Thank you!

P