format 3/1/2004 to 20040301 (yyyymmdd)? 1

[Dan01]

Is there a function I can use in a TRANSACT-SQL statement to make this date conversion? Thanks, Dan.

 

[cheerio]

select convert(varchar, GETDATE(), 112) will format the date in the way you want, for example

 

[bdreed35]

Try this:

declare @mydate datetime

set @mydate = '03/01/2004'

select convert(char(8),@mydate,112)

You only need the last line of the code if you already have a date field. Just swap @mydate with your field.

~Brian

 

[dan1967]

Try using the following:

select replace(convert(char(10), getdate(), 121), '-', '')

CONVERT is changing the date to the format yyyy-mm-dd hh:mi:ss.mmm(24h), and only returning the first 10 characters. REPLACE is removing the '-' only leaving you with the format you are looking for.

Dan.

 

[Dan01]

Thanks Brian and Dan! Dan.