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
