修改发布时间不超过发文时间6天

最新推荐文章于 2022-04-14 23:41:08 发布

RabinRow

最新推荐文章于 2022-04-14 23:41:08 发布

阅读量111

点赞数

原文链接：http://www.cnblogs.com/wenghaowen/p/3512314.html

版权

UPDATE  dbo.T_ARTICLE
        SET     PUBLISH_TIME = DATEADD(DAY,
                                       6 - DATEDIFF(day, FILE_TIME,
                                                    PUBLISH_TIME),
                                       PUBLISH_TIME)
        WHERE   PUBLISH_TIME >= '2014/01/06'
                AND FILE_TIME IS NOT NULL
                AND DATEDIFF(DAY, FILE_TIME, PUBLISH_TIME) > 7

转载于:https://www.cnblogs.com/wenghaowen/p/3512314.html