Get DATE from DATETIME Column in SQL Server

Question

The entry lock date is every month 10thI want any date older than the entry date to be entered as a locked date in SQL server table

dharmendr · Accepted Answer

You need to check the Date using DATEPART function with GETDATE functionExampleDECLARE Date DATETIME  392022121039SELECT CASE WHEN DATEPARTDD Date lt 10 THEN 1ELSE 0ENDOutput1

Get DATE from DATETIME Column in SQL Server

Company

Explore

Follow us

Contact Us