getdate

Returns the current system date and time.

Syntax

getdate()

Examples

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute getdate.

Related concepts
Date and Time Datatypes
Related reference
dateadd
datediff
datename
datepart