TIME_DIFFERENCE_UDF

Warning: This UDF is deprecated because there is already an equivalent function in Snowflake. More information here.

Definition

Gets the difference between two times.

PUBLIC.TIME_DIFFERENCE_UDF
(MINUEND TIME, SUBTRAHEND TIME, INPUT_PART VARCHAR)

Parameters

MINUEND TIMESTAMP

Time subtracted from.

SUBTRAHEND TIMESTAMP

Time subtracted.

INPUT_PART VARCHAR

Parts to be returned.

EXTRACT_PART VARCHAR

Extract numeric value extracted from the interval.

Returns

A varchar value with the time.

Example

Input:

IN -> Teradata_01.sql

select extract(day from (timestampColumn1 - timestampColumn2 day to hour)) from tableName;

Output:

OUT -> Teradata_01.sql

SELECT
EXTRACT_TIMESTAMP_DIFFERENCE_UDF(timestampColumn1, timestampColumn2, 'DAY TO HOUR', 'DAY')
                                 from
tableName;