How to Convert datetime value to yyyymmddhhmmss in SQL server?

Question

How to convert datetime value to yyyymmddhhmmss?

for example From 2014-04-17 13:55:12

To 20140417135512

Answer 1

Since SQL Server Version 2012 you can use:

SELECT format(getdate(),'yyyyMMddHHmmssffff') 

Answer 2

This seems to work:

declare @d datetime set @d = '2014-04-17 13:55:12'  select replace(convert(varchar(8), @d, 112)+convert(varchar(8), @d, 114), ':','')  

Result:

20140417135512