SQL时间格式转换问题
如何将字符串
20110414211328056
转换为
2011-04-14 21:13:28:056
SQL语句
20110414211328056
转换为
2011-04-14 21:13:28:056
SQL语句
作者: hank212 发布时间: 2011-06-15
按位去拼接.
作者: kingtiy 发布时间: 2011-06-15
只能一段一段提取出来再拼接了
作者: aspwebchh 发布时间: 2011-06-15
如果没有好的方法,只能这样了。。。
作者: hank212 发布时间: 2011-06-15
用substing拼接
作者: fredrickhu 发布时间: 2011-06-15
declare @timevarchar varchar(30);
set @timevarchar ='20110414211328056'
set @timevarchar =RTRIM(LTRIM (@timevarchar))
set @timevarchar =SUBSTRING (@timevarchar ,1,4)+'-'+SUBSTRING (@timevarchar ,5,2)+'-'+SUBSTRING (@timevarchar ,7,2)
+' '+SUBSTRING (@timevarchar ,9,2)+':'+SUBSTRING (@timevarchar ,11,2)+':'+SUBSTRING (@timevarchar ,13,2)
+':'+SUBSTRING (@timevarchar ,15,3)
select @timevarchar
set @timevarchar ='20110414211328056'
set @timevarchar =RTRIM(LTRIM (@timevarchar))
set @timevarchar =SUBSTRING (@timevarchar ,1,4)+'-'+SUBSTRING (@timevarchar ,5,2)+'-'+SUBSTRING (@timevarchar ,7,2)
+' '+SUBSTRING (@timevarchar ,9,2)+':'+SUBSTRING (@timevarchar ,11,2)+':'+SUBSTRING (@timevarchar ,13,2)
+':'+SUBSTRING (@timevarchar ,15,3)
select @timevarchar
作者: tcjacky 发布时间: 2011-06-15
SQL code
哈,写着玩玩
select substring('20110414211328056',1,4)+'-'+substring('20110414211328056',5,2)+'-' +substring('20110414211328056',7,2)+' '+substring('20110414211328056',9,2)+':'+ substring('20110414211328056',11,2)+':'+substring('20110414211328056',13,2)+':'+substring('20110414211328056',15,3)
哈,写着玩玩
作者: yubofighting 发布时间: 2011-06-15