590
社区成员
发帖
与我相关
我的任务
分享
select CONVERT(datetime,
(CONVERT(varchar(100), DepartureDate,23)+' '+SUBSTRING(DepartureTime,1,2)+
':'+SUBSTRING(DepartureTime,3,2))) as ddd from
tpTicket
-- 用这个,比较简单
with tpTicket as (
select convert(datetime,'2012-10-18 00:00:00.000') dd,'0715' dt
)
select DATEADD(minute, dt/100 * 60 + dt%100, dd) result
from tpTicket
result
-----------------------
2012-10-18 07:15:00.000
(1 行受影响)
SELECT CONVERT(datetime,
(CONVERT(varchar(100), DepartureDate,23)+' '+
SUBSTRING(DepartureTime,1,2)+ ':'+
SUBSTRING(DepartureTime,3,2)
+':00' -- 加上秒
),
21 -- 字符串转时间尤其要指定格式
) AS ddd
FROM tpTicket
select convert(datetime,convert(varchar(10),departuredate,23)+' '+substring(departuretime,1,2)+':'+substring(departuretime,3,2)) from tpTicket