CURRENT_TIME
SQL - Functions
CURRENT_TIME
Returns the current local time
1998-04-15
CURRENT_TIME
1998-04-15
Inputs
None.
1998-04-15
Outputs
time
Returns "now"
1998-04-15
Description
The niladic CURRENT_TIME function has a data type of
TIME and returns the local time when it is run.
1998-04-15
Notes
Refer to the SET TIME ZONE statement for a further description
of local time.
Usage
Display CURRENT_TIME:
SELECT CURRENT_TIME AS now;
now
-----------
17:41:31+02
Compatibility
1998-04-15
SQL92
SQL92 specifies some additional capabilities for CURRENT_TIME:
CURRENT_TIME [ (scale) ]
The optional scale for CURRENT_TIME, if specified, is an
unsigned integer representing the number of digits in the
optional seconds fraction of the time value represented
by the function.