INTERVAL_TO_SECONDS_UDF
Definition
Transforms interval to seconds.
Parameters
INPUT_PART VARCHAR
The interval to be converted to seconds.
INPUT_VALUE VARCHAR
The type to be converted. E.g. 'DAY', 'DAY TO HOUR', etc.
Returns
A decimal with the processed interval as seconds.
Last updated