MIDNIGHT_SECONDS

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-MIDNIGHT_SECONDS--(--expression--)--------------------------><
 

The MIDNIGHT_SECONDS function returns an integer value that is greater than or equal to 0 and less than or equal to 86 400(R) representing the number of seconds between midnight and the time value specified in the argument.

expression
The argument must be an expression that returns a value of one of the following built-in data types: a time, a timestamp, a character string, or a graphic string. It must not be a CLOB or DBCLOB and its value must be a valid string representation of a time or timestamp. For the valid formats of string representations of times and timestamps, see String representations of datetime values.

The result of the function is large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Examples