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  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  bcp converting datetime

Author  Topic  dcsnfh Starting Member 1 Post Posted - 2005-06-20 : 09:04:55 I have the a flat file (that i cant modify) with the following values 002 TEXTTEXT 06/02/05 The date format in the file is mm/dd/yy but database format is dd/mm/yyyy (spanish). After using BCP inserted values looks like 06-02-2005 but real value is 02-06-2005. How can i prevent this behavior? Can i set a convert instruction inside my .fmt file? Thanks in advance