Convert a datetime column into a specific date format. (T-SQL)

Question

I have a datetime column (SellDate) that I want to output in the following format:

mm/dd/yyyy

such as 06/01/1998

How would I do this? Thanks in advance!

Solution

Convert it to a string with the appropriate conversion style;

convert(varchar(10), thedatecol, 101)

Comments

[marc_s]

See Books Online: CAST and CONVERT which has a complete list of all supported formats for CONVERT