SQL Server 101 – Return the Current DateTime

If you want to return the current date time in SQL Server , the easiest way to do it is using the GETDATE() function.

How to return the Current DateTime in SQL Server ?

The GETDATE() function returns the current date along with the time.

SELECT GETDATE()