NOW Function [Date and Time]

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

Syntax

NOW ( * )

Returns

TIMESTAMP

Standards and Compatibility

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

  • Sybase—Not supported by Adaptive Server Enterprise.

Example

The following statement returns the current date and time.

SELECT NOW(*) FROM iq_dummy
Parent topic: Alphabetical List of Functions