Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the current year, month, day, hour, minute, second, and fraction of a second.
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.
The following statement returns the system date and time:
SELECT GETDATE( );
Syntax