DATEDIFF_UDF(TIMESTAMP, DATE)
Definition
This user-defined function (UDF) is used to subtract a date from a timestamp.
PUBLIC.DATEDIFF_UDF(FIRST_PARAM TIMESTAMP, SECOND_PARAM DATE)Parameters
FIRST_PARAM TIMESTAMP
The timestamp that represents the minuend.
SECOND_PARAM DATE
The date that represents the subtrahend.
Returns
Returns an integer with the difference between the timestamp and the date.
Usage example
Input:
SELECT PUBLIC.DATEDIFF_UDF('2024-01-26 22:00:50.708 -0800', TO_DATE('2023-01-26'));Output:
365Last updated