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