SQLSERVER 数据库日期转换字符串函数

SqlServer里DateTime转字符串
 
Sql代码  
Select CONVERT(varchar(100),GETDATE(),8):14:53:14  
Select CONVERT(varchar(100),9): 06  6 2012  2:53:27:953PM  
Select CONVERT(varchar(100),10): 06-06-12   
Select CONVERT(varchar(100),11): 12/06/06    
Select CONVERT(varchar(100),12): 120606  
Select CONVERT(varchar(100),13): 06 06 2012 14:55:23:893    
Select CONVERT(varchar(100),14): 14:55:35:240  
 
Select CONVERT(varchar(100),20): 2012-06-06 14:55:57   
Select CONVERT(varchar(100),21): 2012-06-06 14:56:09.170  
Select CONVERT(varchar(100),22): 06/06/12  2:56:21 PM  
Select CONVERT(varchar(100),23): 2012-06-06     
Select CONVERT(varchar(100),24): 14:57:01    www.2cto.com    
Select CONVERT(varchar(100),25): 2012-06-06 14:57:11.837    
Select CONVERT(varchar(100),100): 06  6 2012  2:57PM    
Select CONVERT(varchar(100),101): 06/06/2012     
Select CONVERT(varchar(100),102): 2012.06.06     
Select CONVERT(varchar(100),103): 06/06/2012   
Select CONVERT(varchar(100),104): 06.06.2012     
Select CONVERT(varchar(100),105): 06-06-2012     
Select CONVERT(varchar(100),106): 06 06 2012    
 
Select CONVERT(varchar(100),107): 06 06,2012    
Select CONVERT(varchar(100),108): 14:58:28   
Select CONVERT(varchar(100),109): 06  6 2012  2:58:34:133PM    
Select CONVERT(varchar(100),110): 06-06-2012   
Select CONVERT(varchar(100),111): 2012/06/06   
Select CONVERT(varchar(100),112): 20120606    
 
Select CONVERT(varchar(100),113): 06 06 2012 14:58:58:960  
Select CONVERT(varchar(100),114): 14:59:08:527    
Select CONVERT(varchar(100),120): 2012-06-06 14:59:14     
Select CONVERT(varchar(100),121): 2012-06-06 14:59:21.277    
Select CONVERT(varchar(100),126): 2012-06-06T14:59:28.190    
Select CONVERT(varchar(100),130): 17 ??? 1433  2:59:36:540PM    
Select CONVERT(varchar(100),131):17/07/1433  3:00:00:090PM  

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!