Import Wizard Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Import Wizard Issue

Author

Topic

Rach2009
Starting Member

37 Posts

Posted - 2010-02-25 : 06:04:33

Hi All,

I am currently trying to use the fllowing SQL statement in the "Provide a Source Query" stage in the Import wizard:-

SELECT * FROM "DCSDBA"."SKU_AUDIT" WHERE "AUDIT_DSTAMP"='24/02/2010'

But it won't work as it says I am using an "invalid month". Any ideas why I am getting this error message back? I have also tried the american version of 02/24/2010, but get the same error message.

Many Thanks

Rachel

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2010-02-25 : 12:35:23

what is Audit_dstamp data type?

With Regards
SR

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2010-02-25 : 12:38:16

Try like this ...

SELECT * FROM "DCSDBA"."SKU_AUDIT" WHERE "AUDIT_DSTAMP"= Convert(datetime,'24/02/2010',103)
Note that 103 is for British/French dd/mm/yy format.

With Regards
SR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources