TO_TERA_DATE

Learn how to use the TO_TERA_DATE date/time function in PlaidCloud Lakehouse. Converts a VARCHAR value to a DATE value according to a Teradata format string.

Converts a VARCHAR value to a DATE value according to a Teradata format string.

Analyze Syntax

func.to_tera_date(<str>, <format>)

Analyze Examples

func.to_tera_date('20240615', 'YYYYMMDD')

┌──────────────┐
│ '2024-06-15'  │
└──────────────┘

SQL Syntax

TO_TERA_DATE(<str>, <format>)

SQL Examples

SELECT TO_TERA_DATE('20240615', 'YYYYMMDD');

┌────────────┐
│ 2024-06-15  │
└────────────┘