Cancel

datediff with in operator

Posted May 23, 2019 2019-05-23T00:00:00+08:00 by PipisCrew

select * from table
where daterec is not null and DATEDIFF(d, daterec ,getdate()) in (5,12)

origin - https://www.pipiscrew.com/?p=14934 datediff-with-in-operator

This post is licensed under CC BY 4.0 by the author.

Contents