469,356 Members | 2,045 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

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

Jul 6 '07 #1
2 8956
Piero 'Giops' Giorgi (gi**********@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, es****@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
Jul 6 '07 #2
On Jul 6, 2:43 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
The ultimate guide to date formats on SQL Server:http://www.karaszi.com/SQLServer/info_datetime.asp
Thank you!

P

Jul 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by TonyMontana | last post: by
1 post views Thread by Ralph Noble | last post: by
reply views Thread by youwater | last post: by
1 post views Thread by David Berry | last post: by
2 posts views Thread by othellomy | last post: by
reply views Thread by Philip Kline | last post: by
3 posts views Thread by t8ntboy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.