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

Answers

Re: BCP in datetime values in nondefault format.

Jesus,

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.

Eric

-- Anonymous, November 03, 1998