SQL Server 中日期加减的方法
SELECT datediff(day,DOC_RYGL_YGDA.RZSJ,getdate()) AS day ,
datediff(month,DOC_RYGL_YGDA.RZSJ,getdate()) as month ,
datediff(year,DOC_RYGL_YGDA.RZSJ,getdate()) as year
FROM DBO.DOC_RYGL_YGDA DOC_RYGL_YGDA
工作中自己写的或搜到的一些资料,做个备份,方便以后查找。
SELECT datediff(day,DOC_RYGL_YGDA.RZSJ,getdate()) AS day ,
datediff(month,DOC_RYGL_YGDA.RZSJ,getdate()) as month ,
datediff(year,DOC_RYGL_YGDA.RZSJ,getdate()) as year
FROM DBO.DOC_RYGL_YGDA DOC_RYGL_YGDA
发帖者
Kevin
时间:
17:51
标签: SQL Server
没有评论:
发表评论