Updated on Kisan Patel
This tutorial will show you how to get current Date and time in SQL Server?
To get current date and time in SQL Server, we can use GETDATE()
or SYSDATETIME()
functions.
SELECT GETDATE()
SELECT SYSDATETIME()
The first GETDATE()
function gives the current date and time, the second SYSDATETIME
gives more precise value.