Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

NOW function [Date and time]

Returns the current year, month, day, hour, minute, second, and fraction of a second. The accuracy is limited by the accuracy of the system clock.

NOW( * )

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

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

• SQL/2003    Vendor extension.

The following statement returns the current date and time.

SELECT NOW( * );