有一列数据，全部是varchar类型
例如
20111108132831
如何在查询分析器里面转换为
2011-11-08 13:28:31
谢谢！
------解决方案--------------------
- SQL code
declare @dt varchar(20)set @dt='20111108132831'select convert(datetime,stuff(stuff(STUFF(@dt,9,0,' '),12,0,':'),15,0,':'))/*-----------------------2011-11-08 13:28:31.000(1 行受影响)*/
------解决方案--------------------
- SQL code
select convert(datetime,stuff(stuff(STUFF(orderdate,9,0,' '),12,0,':'),15,0,':'))from tb