MS SQL Show Only Date of Current Time

In MS SQL Server, we get the current time with the getdate() method. But this method gives us results with hours, minutes, seconds and milliseconds.

If we want to get the current time in year, month, day format only, the following query should be run.

SELECT CONVERT(date, getdate()) AS ourVarName


You May Interest

What is SQL Server Agent ?

Creating a Stored Procedure in MS SQL

What is Resource Governor in SQL Server ?

What are Sparse Columns in SQL Server ?

What are Some Advantages of Using CTE in SQL Server ?