sql - 在 SELECT 查询中组合 SQL Server 中的日期和时间

Question

我有 From我的表中的日期，但我想为其添加修复时间

我正在尝试这样

select cast(FromDate as date) + cast('18:00:00' as time(3)) as StartDT 
from WsWmpLeaveReason

但这会导致错误:

Operand data type date is invalid for add operator.

Answer 1

使用 DATEADD :

SELECT
   DATEADD(HOUR, 18, CAST(CAST(FromDate AS DATE) AS DATETIME)) as StartDT 
FROM
   WsWmpLeaveReason

见 freely available, comprehensive SQL Server Books Online documentation欲知更多详情 DATEADD及其选项