[SQL] Provide Datetime formatting while BCP export

BCP export outputs dates in yyyy-mm-dd format, I need them to be in yyyy.mm.dd format. The export file is consumed by another application which is rigid. I am going to do bcp export for large number of tables and it would be great if I can apply this formatting to all date columns in a result set without explicitly specifying the date columns.

Continue reading...