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


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
How to get the date part from the date time in SQL Server ?
Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

%d bloggers like this: