How to Get the Current Date in SQL Server

Problem

You’d like to get the current date in an SQL Server database.

Solution

SELECT CAST(GETDATE() AS DATE);

Result:

2021-03-11

Discussion

GETDATE() is a function that returns the current date and time. Arguments are not required. If you use just the GETDATE() function, you will get:

2021-03-11 22:28:17.280

If you want to get only the date and not the time, you need to use another function, CAST(). In the parentheses, specify the value, expression, or column you want to convert from, AS, then finally the type of value you want to get (in our solution, DATE).