Below are
the SQL statements by which we can get the required formats:
the SQL statements by which we can get the required formats:
- DDMMYYYYHHMMSSMMM format :
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103),‘/’,”) +
REPLACE(CONVERT(VARCHAR(12), GETDATE(), 114) ,‘:’,”)
- YYYYMMDDHHMMSSMMM
format :
SELECT REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(),
121),‘-‘,”),‘:’,”),‘.’,”),‘ ‘,”)
