SQListic (4/18/2014)
Hi All,I The requirement is to unload all columns data into csv file using bcp with pipe delimitter, but the condition is to remove milliseconds part of a datetime column.
Ex:
2014-02-19 17:12:14.967 remove .967 from data while unloading into csv.
So write a view that shows the output you want and BCP from that.
--Jeff Moden
Change is inevitable... Change for the better is not.