这是oracle的函数如果转成sql server函数
TO_DATE(TO_CHAR(rqsj,'YYYY/MM/DD')||' '||SUBSTR(xssj,1,2)||':'||SUBSTR(xssj,3,2),'YYYY/MM/DD HH24:MI') 谢谢!
TO_DATE(TO_CHAR(rqsj,'YYYY/MM/DD')||' '||SUBSTR(xssj,1,2)||':'||SUBSTR(xssj,3,2),'YYYY/MM/DD HH24:MI') 谢谢!
总之用convert或cast( '' as datetime)
--貌似是这样
select cast(convert(char(10),rqsj,120)+' '+left(xssj,2)+':'+substring(xssj,3,2) as datetime)