SQL 中将14位数字快速转换为时间
示例
declare @str varchar(14)
set @str='20080210182031'
select cast(left(@str,8) as datetime)+stuff(stuff(right(@str,6),3,0,':'),6,0,':')
输出结果
2008-02-10 18:20:31.000
No accident,Everyone is No 1.
示例
declare @str varchar(14)
set @str='20080210182031'
select cast(left(@str,8) as datetime)+stuff(stuff(right(@str,6),3,0,':'),6,0,':')
输出结果
2008-02-10 18:20:31.000