Returns the current timestamp.
The fields in CURRENT_TIMESTAMP are:
- YEAR
- MONTH
- DAY
- HOUR
- MINUTE
- SECOND
The seconds precision of the result of CURRENT_TIMESTAMP is limited to hundredths of a second. CURRENT_TIMESTAMP returns zeros for any digits to the right of the two most significant digits in the fractional portion of seconds.
- TIMEZONE_HOUR
- TIMEZONE_MINUTE
See the following sections:
Also see CREATE PROCEDURE (SQL Form).ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.