How to Convert datetime value to yyyymmddhhmmss in SQL server?

datetime-format, sql-server-2008-r2

Solution

Since SQL Server Version 2012 you can use:

SELECT format(getdate(),'yyyyMMddHHmmssffff')

Problem

Original source