BCP and date formats

[BeachSand]

Hi,

Is there a way to programmatically accept different date formats in BCP or BULK INSERT? The application will import from different data source which will probably have different date formats.

Is the better answer to require that the files be sent with a specific date format?

Thanks.

- Beach

 

[DrSql]

Requesting to send the file in a specific format, that would be easier for you donw the line. If you still want to proceed with diff dates you might have to find out how many formats they will be sending, then you can use a case

[tt]
CASE when date=format1 then cast or convert (date1)
when date=format2 then cast or convert (date2)
when date=format2 then cast or convert (date3)
end
[/tt]


Dr.Sql
Good Luck.