SECONDS_PAST_MIDNIGHT_UDF
Definition
Process how many seconds have passed since midnight for a given time.
PUBLIC.SECONDS_PAST_MIDNIGHT_UDF(INPUT TIME)
Parameters
INPUT
TIME
The time to calculate how many seconds have passed since midnight.
Returns
A varchar
that indicates how many seconds have passed since midnight.
Usage example
Input:
SELECT PUBLIC.SECONDS_PAST_MIDNIGHT_UDF(TIME'10:30:45');
Output:
'37845'
Last updated