This content was proof-read by Grammarly. You can Try Grammary for FREE
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