Returns the current time.
The fields in CURRENT_TIME are:
- HOUR
- MINUTE
- SECOND
The seconds precision of the result of CURRENT_TIME is limited to hundredths of a second. CURRENT_TIME returns zeros for any digits to the right of the two most significant digits in the fractional portion of seconds.
- TIMEZONE_HOUR
- TIMEZONE_MINUTE
CURRENT_TIME provides similar functionality to the Teradata function TIME using ANSI-compliant syntax. For information on the Teradata TIME function, see TIME.