GETDATE function [Date and time]

Function

Returns the current date and time.

Syntax

GETDATE ()

Example

The following statement returns the system date and time.

SELECT GETDATE( ) FROM iq_dummy

Usage

GETDATE is a Transact-SQL compatible data manipulation function.

Standards and compatibility