MIDNIGHT_SECONDS scalar function
Returns an integer value in the range 0 to 86 400, representing the number of seconds between midnight and the time value specified in the argument.
The schema is SYSFUN.
- expression
- An expression that returns a value of one of the following built-in data types: DATE, TIME, TIMESTAMP, or a valid character string representation of a date, time, or timestamp that is not a CLOB. If the expression is a DATE or a valid string representation of a date, it is first converted to a TIMESTAMP(0) value, assuming a time of exactly midnight (00.00.00). In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string before the function is executed.
The result of the function is INTEGER. The result can be null; if the argument is null, the result is the null value.
Examples
- Example 1: Find the number of seconds between midnight
and 00:10:10, and midnight and 13:10:10.
This example returns the following:VALUES (MIDNIGHT_SECONDS('00:10:10'), MIDNIGHT_SECONDS('13:10:10'))1 2 ----------- ----------- 610 47410Since a minute is 60 seconds, there are 610 seconds between midnight and the specified time. The same follows for the second example. There are 3600 seconds in an hour, and 60 seconds in a minute, resulting in 47 410 seconds between the specified time and midnight.
- Example 2: Find the number of seconds between midnight
and 24:00:00, and midnight and 00:00:00.
This example returns the following:VALUES (MIDNIGHT_SECONDS('24:00:00'), MIDNIGHT_SECONDS('00:00:00'))1 2 ----------- ----------- 86400 0Note that these two values represent the same point in time, but return different MIDNIGHT_SECONDS values.