You can use the convert function in SQL Server to retrieve only the date part from the date time.
How to get the Date part from DateTime variable in SQL Server ?
Here’s a sample code snippet demonstrating how to do it.
SELECT CONVERT(DATE, GETDATE())
The GETDATE returns the current date along with the time and the convert function extracts only the DATE part of it.
Enter your email address to subscribe to this blog and receive notifications of new posts by email.