Contents Index NEXT_HTTP_VARIABLE function [HTTP] NULLIF function [Miscellaneous]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

NOW function [Date and time]


Function 

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.

Syntax 

NOW ( * )

Standards and compatibility 
See also 

GETDATE function [Date and time]

CURRENT TIMESTAMP special value

Example 

The following statement returns the current date and time.

SELECT NOW(*)

Contents Index NEXT_HTTP_VARIABLE function [HTTP] NULLIF function [Miscellaneous]