SSIS 获取当天日期

最新推荐文章于 2021-06-29 11:59:37 发布

_iorilan

最新推荐文章于 2021-06-29 11:59:37 发布

阅读量4.2k

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/lan_liang/article/details/78571518

版权

数据库专栏收录该内容

40 篇文章 0 订阅

订阅专栏

SSIS获取今天的日期yy-mm-dd

RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2) + "-" +  (DT_STR, 4, 1252) DATEPART("yy" , GETDATE())

当天yyyy-mm-dd 23:59:59>=变量日期>=当天yyyy-mm-dd 00:00:00

(DT_STR, 4, 1252) DATEPART("yy" , dateadd("day",1, @[User::startdate] )) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , dateadd("day",1,@[User::startdate])), 2) +"-"+RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , dateadd("day",1,@[User::startdate])), 2) + " 00:00:00"


<={yourdate} <=


(DT_STR, 4, 1252) DATEPART("yy" , dateadd("day",1, @[User::startdate] )) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , dateadd("day",1,@[User::startdate])), 2) +"-"+RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , dateadd("day",1,@[User::startdate])), 2) + " 23:59:59"