SQL Server2005中的时间格式

2022-07-15 80酷酷网 80kuku.com

　　server

select CONVERT(varchar(12) , getdate(), 111 ) as '1'
--2007/01/26

select CONVERT(varchar(12) , getdate(), 112 ) as '2'
--20070126

select CONVERT(varchar(12) , getdate(), 102 ) as '3'
--2007.01.26

select CONVERT(varchar(12) , getdate(), 101 ) as '4'
--01/26/2007

select CONVERT(varchar(12) , getdate(), 103 ) as '5'
--26/01/2007

select CONVERT(varchar(12) , getdate(), 104 ) as '6'
--26.01.2007

select CONVERT(varchar(12) , getdate(), 105 ) as '7'
--26-01-2007

select CONVERT(varchar(12) , getdate(), 106 ) as '8'
--26 Jan 2007

select CONVERT(varchar(12) , getdate(), 107 ) as '9'
--Jan 26, 2007

select CONVERT(varchar(12) , getdate(), 108 ) as '10'
--10:10:09

select CONVERT(varchar(12) , getdate(), 109 ) as '11'
--Jan 26 2007

select CONVERT(varchar(12) , getdate(), 110 ) as '12'
--01-26-2007

select CONVERT(varchar(12) , getdate(), 113 ) as '13'
--26 Jan 2007

select CONVERT(varchar(12) , getdate(), 114 ) as '14'
--10:10:09:530