NOW Function [Date and Time]

Returns the current date and time. This is the historical syntax for CURRENT TIMESTAMP.

Syntax

NOW ( * )

Returns

TIMESTAMP

Example

The following statement returns the current date and time.

SELECT NOW(*) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions