DATEDIFF_UDF(DATE, DATE)
Definition
This user-defined function (UDF) is used when there is a subtraction between two dates.
PUBLIC.DATEDIFF_UDF(FIRST_PARAM DATE, SECOND_PARAM DATE)Parameters
FIRST_PARAM DATE
The date that represents the minuend in the subtraction.
SECOND_PARAM DATE
The date that represents the subtrahen in the subtraction.
Returns
Returns an integer with the number of days between the dates.
Usage example
Input:
SELECT PUBLIC.DATEDIFF_UDF(TO_DATE('2024-01-26'), TO_DATE('2023-01-26'));Output:
365Last updated