SQL Functions

CURRENT_TIME

The CURRENT_TIME function returns the current date 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_TIME

top

Example

select company,

current_time

from customers
where company='dynamic'

...

Dynamic Information Systems Corporation, 14:44:56.00

top