求教sql语句两个日期、时间字段相减得到天数小时分秒的问题答:select requestid,userid,workflowid,receivedate,receivetime,operatedate,operatetime,cast(day as varchar)+'天'+cast((hour-day*24) as varchar)+'小时'+cast((minute-hour*60) as varchar)+'分'+cast((second-minute*60) as varchar)+'秒' resultfrom(select requestid,userid,workflowid,...
sql 日期相减答:select datediff(year, 开始日期,结束日期); --两日期间隔年select datediff(quarter, 开始日期,结束日期); --两日期间隔季select datediff(month, 开始日期,结束日期); --两日期间隔月select datediff(day, 开始日期,结束日期); --两日期间隔天select datediff(week, 开始日期,结束日期); --两日期间隔周select...