J jesse.zhou Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-04 #1 1:m char(5) m="07:15" 我想轉成時間型不知怎樣轉 2:m char(5) m="07:15" 我想轉成時間型後加50則變為08:05分,請問怎麼用
Q qianwt Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-04 #4 select convert(varchar(5),dateadd(mi,50,convert(datetime,'2002-01-01 '+'07:15')),108)