TO_TERA_TIMESTAMP
Converts a VARCHAR value to a DATETIME value according to a Teradata format string.
Analyze Syntax
func.to_tera_timestamp(<str>, <format>)
Analyze Examples
func.to_tera_timestamp('20240615143000', 'YYYYMMDDHH24MISS')
┌───────────────────────┐
│ '2024-06-15 14:30:00' │
└───────────────────────┘
SQL Syntax
TO_TERA_TIMESTAMP(<str>, <format>)
SQL Examples
SELECT TO_TERA_TIMESTAMP('20240615143000', 'YYYYMMDDHH24MISS');
┌─────────────────────┐
│ 2024-06-15 14:30:00 │
└─────────────────────┘