How to get the date part from the date time in SQL Server ?

If you are on SQL Server 2008 and higher version and want to get the date part of the datetime data in SQL Server , you can use the CONVERT method as shown in this post.

How to get the date part from the date time in SQL Server ?

If you want to get the current date leaving out the time from the datetime type , you can use this query.

SELECT CONVERT(date, getdate()) as DateValue
How to get the date part from the date time in SQL Server ?
%d