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.
- CURRENT_TIME/CURTIME Function Syntax
- CURRENT_TIME Result Type and Attributes
- CURRENT_TIME/CURTIME Usage Notes
- CURRENT_TIME/CURTIME Function Examples
ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.