Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server - Date and Time Functions

This article describes the Transact-SQL date and time functions supported by Microsoft SQL Server.


Function Description
GETDATE() Returns the current system date and time.


Syntax GETDATE()
Parameter The function requires no arguments.
Description Returns the current system date and time.
Return Type DATETIME
Notice GETDATE is a nondeterministic function. Views and expressions that reference this column cannot be indexed.
Date functions can be used in the SELECT statement select list or in the WHERE clause of a query.

Equivalents in Other Databases

Database Equivalent
Oracle SYSDATE - Returns the current date and time.

© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.