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"