Functions

CURRENT_TIMESTAMP

The CURRENT_TIMESTAMP function returns the current timestamp from the system's time-of-day clock.

The function is processed once at the beginning of execution of the SQL statement. A new value is not obtained with each reference or with each fetched row.

Syntax

CURRENT_TIMESTAMP

Example

select company,
current_timestamp
from customers
where company='dynamic'

...
Dynamic Information Systems Corporation, 2003-01-24 14:45:04.00

Top