Posted by Erland Sommarskog on 07/06/07 21:43

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: HELP!! Please .......
• Prev in forum: Re: Sum result of a Select
• Thread view: Re: Import/Export wizard DateTime problem

[Reply to this message]