ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the current year, month, day, hour, minute, second and fraction of a second. The fraction of a second. The accuracy is limited by the accuracy of the system clock.
The information the NOW function returns is equivalent to the information returned by the GETDATE function and the CURRENT TIMESTAMP special value.
NOW ( * )
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
GETDATE function [Date and time]
CURRENT TIMESTAMP special value
The following statement returns the current date and time.
SELECT NOW(*)