SQL Server - Date and Time Functions

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

Overview

Function	Description

GETDATE()	Returns the current system date and time.

SQL Server - GETDATE
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.