整理了一下,数据库中经常会用到的日期转换方式:
select CONVERT(varchar, getdate(), 120 )
2010-09-17 21:13:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20100917211329
select CONVERT(varchar, getdate(), 111 )
2010/09/17
select CONVERT(varchar, getdate(), 112 )
20100917
select CONVERT(varchar, getdate(), 102 )
2010.09.17
select CONVERT(varchar, getdate(), 101 )
09/17/2010
select CONVERT(varchar, getdate(), 103 )
17/09/2010
select CONVERT(varchar, getdate(), 104 )
17.09.2010
select CONVERT(varchar, getdate(), 105 )
17-09-2010
select CONVERT(varchar, getdate(), 106 )
17 09 2010
select CONVERT(varchar, getdate(), 107 )
09 17, 2010
select CONVERT(varchar, getdate(), 108 )
21:11:26
select CONVERT(varchar, getdate(), 109 )
09 17 2010 9:10:42:013PM
select CONVERT(varchar, getdate(), 110 )
09-17-2010
select CONVERT(varchar, getdate(), 113 )
17 09 2010 21:10:03:357
select CONVERT(varchar, getdate(), 114 )
21:09:33:763
当然这里我没有设置varchar()的长度,如果你感觉,返回的字符串太长了,也可设置一下varchar()长度,截断它