![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
Code
1、标准日期+时间格式
select CONVERT(varchar, getdate(), 120)
结果:2009-03-13 11:24:32
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2、标准日期+时间 无间隔格式
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
结果:20090313112523
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3、标准日期格式(显示年月日:示例结果是2009年3月13日)
select CONVERT(varchar(12) , getdate(), 111 )
结果:2009/03/13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(10), getdate(), 120 )
结果:2009-03-13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 112 )
结果:20090313
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 102 )
结果:2009.03.13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 101 )
结果:03/13/2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 103 )
结果:13/03/2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 104)
结果:13.03.2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 105 )
结果:13-03-2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 106 )
结果:13 03 2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 107 )
结果:03 13, 2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 110 )
结果:03-13-2009
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3、标准时间格式(几点几分几秒)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 108 )
结果:11:32:52
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(12) , getdate(), 114 )
结果:11:33:13:263
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4、根据改变上面转换数据类型varchar的长度来获取更多的格式
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
年月组合:
select CONVERT(varchar(7), getdate(), 120 )
结果:2009-03
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(7) , getdate(), 111 )
结果:2009/03
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(6) , getdate(), 112 )
结果:200903
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(8) , getdate(), 102 )
结果:2009.03.
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
月日组合(几月几日):
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(5) , getdate(), 110 )
结果:03-13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
select CONVERT(varchar(5) , getdate(), 109 )
结果:03 13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
由于标准的日期格式都是固定的长度,还有更多个日期和时间格式,可以通过字符串的长度来截取等来获取。
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
posted @
2009-05-13 13:48
无知者
阅读(
223)
评论()
编辑
收藏
举报