Help with BCP in datetime values in nondefault format.greenspun.com : LUSENET : SQL Server Database Administration : One Thread
How Can I BCP in datetime values in nondefault format, wich is "mdy" in U.S. English.
Thanks in advance, for any help...
-- Anonymous, November 02, 1998
I'm afraid that BCP uses only the default date format for reading in date fields. You must use a workaround. Either reformat the import file before BCPing it in, or BCP it into another table, then use SQL to convert it and insert it into your target table.
-- Anonymous, November 03, 1998