how to convert date field to format mmddyyyy

[tmartin99]

I have a date field in a SQL 2000 table that I need to output in the format mmddyyyy and can't seem to find a function to do it?

 

[tlbroadbent]

Use a combination of functions.

Select Replace(Convert(char(10),DateCol,101),'/','')

Convert gives mm/dd/yyyy (style 101)
Replace removes the / by replacing it with an empty string. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[tmartin99]

thanks so much, I'm new to SQL Server, you can do the same function in Oracle using to_char(datefield,'mmddyyyy')