SQL时间计算
select
SKKR_KOJO,A.KOTEI_CD,A.KEY_NO,KATAMEI_BODY,KATAMEI_KURAKI,
W_LOT_NO,SSN_SKKR_SU,(B.KNRYO_YMD+KNRYO_HMS)AS KNRYO_YMD,
(DATEDIFF(DAY,cast((KNRYO_YMD) AS DATETIME),GETDATE()))-(SELECT COUNT(1) FROM dbo.OTT0430 WHERE (KYJT_YMD BETWEEN KNRYO_YMD AND GETDATE())and SKKR_KOJO=KOJO )as [Delay Days],
CQ_RRK,DBG,
BR39,PCKG_CD,BI_SYRYK,KONPO_MAKE_FLG,SCH_MEI,RSN_KHT_KBN,
CONVERT(VARCHAR(255),GETDATE(),111)AS YMD
from dbo.SHIGUA A LEFT JOIN dbo.SHIGUA_KNRYO B ON A.KEY_NO=B.KEY_NO
B.KNRYO_YMD是nchar(2)类型,KNRYO_HMS 是nchar(2)类型;[Delay Days]是float类型。
为什么计算时没有把时分秒计算进去