TIME_DIFFERENCE_UDF

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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:

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

Output:

SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'EXTRACT_TIMESTAMP_DIFFERENCE_UDF' INSERTED. **
EXTRACT_TIMESTAMP_DIFFERENCE_UDF(
                                 --** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'TIMESTAMP_DIFFERENCE_UDF' INSERTED. **
                                 timestampColumn1, timestampColumn2, 'DAY TO HOUR', 'DAY')
                                 from
tableName;