BCP SQL Conversion and Cast Functions for Field Headers and Field Values

BCP SQL Export Conversion and Cast Functions for Field Headers and Field Values

--convert to date string from date time

select convert(varchar(50),getdate(),120)

--convert to number string from number

select convert(varchar(20),1234.56)

--convert to string from unicoe string

select convert(varchar(max),N'Test')