Returns the current year, month, day, hour, minute, second and fraction of a second.

Syntax

GETDATE( ) 

Returns

TIMESTAMP

Remarks

The accuracy is limited by the accuracy of the system clock.

The information the GETDATE function returns is equivalent to the information returned by the NOW function and the CURRENT TIMESTAMP special value.

See also

• NOW function [Date and time]
• CURRENT TIMESTAMP special value

Standards and compatibility

Example

The following statement returns the system date and time.

SELECT GETDATE( );