DATE_LONG_UDF

Definition

Emulates the format element DL in Teradata, which represents a date as 'Day, Month DD, YYYY'.

PUBLIC.DATE_LONG_UDF(INPUT TIMESTAMP_TZ)

Parameters

INPUT TIMESTAMP_TZ

The date to be represented in date long format.

Returns

A VARCHAR with the format element DL of Teradata.

Usage example

Input:

SELECT PUBLIC.DATE_LONG_UDF(DATE '2021-10-26');

Output:

'Tuesday, October 26, 2021'