HomeSQL ServerSQL Server 101 – Return the Current DateTime

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()

Leave a Reply

You May Also Like

When dealing with a relational database management system (RDBMS) like SQL Server, compatibility level is an important concept to understand....
In this blog post, let’s learn about the error message “49975 – Unable to load controller client certificate due to...
In this blog post, let’s learn about the error message “49973 – Cannot remove tempdb remote file to local tempdb...