Import/Export wizard DateTime problem

#1

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

#2

Piero 'Giops' Giorgi (giorgi.piero (AT) gmail (DOT) 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 (AT) sommarskog (DOT) 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

#3

On Jul 6, 2:43 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:

Quote:

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

Thank you!

P

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Import/Export wizard DateTime problem

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Import/Export wizard DateTime problem - 07-06-2007 , 03:30 PM

Re: Import/Export wizard DateTime problem - 07-06-2007 , 04:43 PM

Re: Import/Export wizard DateTime problem - 07-11-2007 , 11:51 AM