GETDATE( ) 

TIMESTAMP

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.

• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• CURRENT UTC TIMESTAMP special value
• DATE data type
• DATE function [Date and time]
• DATETIME data type
• DATETIME function [Date and time]
• DATETIMEOFFSET data type
• Expressions
• ISDATE function [Data type conversion]
• NOW function [Date and time]
• SMALLDATETIME data type
• TIME data type
• TIMESTAMP special value
• TIMESTAMP data type
• UTC TIMESTAMP special value

The following statement returns the system date and time:

SELECT GETDATE( );