Last updated 1 year ago
Transforms interval to seconds.
INPUT_PART VARCHAR
INPUT_PART
The interval to be converted to seconds.
INPUT_VALUE VARCHAR
INPUT_VALUE
The type to be converted. E.g. 'DAY', 'DAY TO HOUR', etc.
A decimal with the processed interval as seconds.
PUBLIC.INTERVAL_TO_SECONDS_UDF (INPUT_PART VARCHAR(30), INPUT_VALUE VARCHAR())