how to format getdate into YYYYMMDDHHmmSS

sql-server-2005 getdate
Wayne picture Wayne · Sep 23, 2011 · Viewed 69.7k times · Source

In SQL Server how do I format getdate() output into YYYYMMDDHHmmSS where HH is 24 hour format?

I've got the YYYYMMDD done with 

select CONVERT(varchar,GETDATE(),112)

but that is as far as I got.

Thanks.

Answer

Richard picture Richard · Oct 22, 2013

Just for anyone searching for this functionality that has SQL Server 2012 you can use the FORMAT function:

SELECT FORMAT ( GETDATE(), 'yyyyMMddHHmmss') AS 'Custom DateTime'

This allows any .NET format strings making it a useful new addition.

Related questions

Rounding SQL DateTime to midnight

I am having a small problem with my SQL query. I'm using the GETDATE function, however, let's say I execute the script at 5PM, it will pull up records between 12/12/2011 5PM to 12/18/2011 5PM. How can I make it pull up …

Read More
How to extract date from a DateNow() in YYYYMMDD format in SQL Server

Got a specific requirement that we should extract only date and in YYYYMMDD format from GETDATE() in Sql-Server 2005. How can I accomplish this. Thanks

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More