如何返回yyyyMMddhhmm日期格式?

Question

本帖最后由 wsxqaz 于 2009-12-02 11:02:15 编辑

Answer 1

select convert(varchar(8),getdate(),112)+replace(convert(varchar(5),getdate(),108),':','')

Answer 2

select convert(varchar(8),getdate(),112)+replace(convert(varchar(5),getdate(),108),':','')
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
200912021110(1 行受影响)
*/

Answer 3

select replace(replace(replace(convert(varchar(19),getDate(),120),'-',''),' ',''),':','')
/*
                     
---------------------
20091202112701（所影响的行数为 1 行）*/