sql server 日期转字符串 格式为yyyyMMddHHmmss

网上搜了一下都没有人写能转成yyyyMMddHHmmss格式的sql，索性自己写一个吧，分享给大家

select

concat(
DATEPART(YYYY,d.CreateTime)
,CASE WHEN DATEPART(MM,d.CreateTime) <10 THEN concat('0',DATEPART(MM,d.CreateTime)) ELSE CAST(DATEPART(MM,d.CreateTime) as varchar(4)) END
,CASE WHEN DATEPART(DD,d.CreateTime) <10 THEN concat('0',DATEPART(DD,d.CreateTime)) ELSE CAST(DATEPART(DD,d.CreateTime) as varchar(4)) END 
,CASE WHEN DATEPART(HH,d.CreateTime) <10 THEN concat('0',DATEPART(HH,d.CreateTime)) ELSE CAST(DATEPART(HH,d.CreateTime) as varchar(4)) END  
,CASE WHEN DATEPART(MI,d.CreateTime) <10 THEN concat('0',DATEPART(MI,d.CreateTime)) ELSE CAST(DATEPART(MI,d.CreateTime) as varchar(4)) END  
,CASE WHEN DATEPART(SS,d.CreateTime) <10 THEN concat('0',DATEPART(SS,d.CreateTime)) ELSE CAST(DATEPART(SS,d.CreateTime) as varchar(4)) END) ‘yyyyMMddHHmmss’

实际时间为：2021-10-21 17:03:09

结果为：20211021170309