SQL日期格式转换
SQL日期格式转转
select CONVERT(varchar, getdate(), 120 )2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select COUNVRT(varchar(12) , getdate(), 23 )2008-04-01
select CONVERT(varchar(12) , getdate(), 111 )2004/09/12
select CONVERT(varchar(12) , getdate(), 112 )20040912
select CONVERT(varchar(12) , getdate(), 102 )2004.09.12
其它不常用的日期格式
方法
快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载
转转转转:
select CONVERT(varchar(12) , getdate(), 101 )09/12/2004
select CONVERT(varchar(12) , getdate(), 103 )12/09/2004
select CONVERT(varchar(12) , getdate(), 104 )12.09.2004
select CONVERT(varchar(12) , getdate(), 105 )12-09-2004
select CONVERT(varchar(12) , getdate(), 106 )12 09 2004
select CONVERT(varchar(12) , getdate(), 107 )09 12, 2004
select CONVERT(varchar(12) , getdate(), 108 )11:06:08
select CONVERT(varchar(12) , getdate(), 109 )09 12 2004 1
select CONVERT(varchar(12) , getdate(), 110 )09-12-2004
select CONVERT(varchar(12) , getdate(), 113 )12 09 2004 1
select CONVERT(varchar(12) , getdate(), 114 )
11:06:08.177
以下是不同的数不同的格式转转转转转转转转转转
0 = Nov 14 2011 11:00AM
1 = 11/14/11
2 = 11.11.14
3 = 14/11/11
4 = 14.11.11
5 = 14-11-11
6 = 14 Nov 11
7 = Nov 14, 11
8 = 11:00:01
9 = Nov 14 2011 11:00:01:950AM10 = 11-14-11
11 = 11/11/14
12 = 111114
13 = 14 Nov 2011 11:00:01:95014 = 11:00:01:950
20 = 2011-11-14 11:00:0121 = 2011-11-14 11:00:01.95022 = 11/14/11 11:00:01 AM23 = 2011-11-14
24 = 11:00:01
25 = 2011-11-14 11:00:01.950100 = Nov 14 2011 11:00AM101 = 11/14/2011
102 = 2011.11.14
103 = 14/11/2011
104 = 14.11.2011
105 = 14-11-2011
106 = 14 Nov 2011
107 = Nov 14, 2011
108 = 11:00:01
109 = Nov 14 2011 11:00:01:950AM110 = 11-14-2011
111 = 2011/11/14
112 = 20111114
113 = 14 Nov 2011 11:00:01:950114 = 11:00:01:950
120 = 2011-11-14 11:00:01121 = 2011-11-14 11:00:01.950126 = 2011-11-14T11:00:01.950127 = 2011-11-14T11:00:01.950130 = 18 ?? ????? 1432 11:00:01:950AM
131 = 18/12/1432 11:00:01:950AM