Returns the current transaction timestamp where the evaluation is based on the session time zone.
The seconds precision of the result of TEMPORAL_TIMESTAMP is limited to hundredths of a second. TEMPORAL_TIMESTAMP returns zeros for any digits to the right of the two most significant digits in the fractional portion of seconds.
- TEMPORAL_TIMESTAMP Function Syntax
- TEMPORAL_TIMESTAMP Result Type and Attributes
- TEMPORAL_TIMESTAMP Usage Notes
Also see:
- Teradata Vantage™ - ANSI Temporal Table Support, B035-1186
- Data Type Formats and Format Phrases