Name
spm — convert time to seconds past midnight
Synopsis
double precision
spm
(
|
tvalue); |
|
time
tvalue
;
double precision
spm
(
|
tvalue); |
|
interval
tvalue
;
double precision
spm
(
|
tvalue); |
|
timestamp
tvalue
;
time(0)
tvalue
;
Input
tvalue
A time, interval or timestamp.
Description
A function which returns the number of seconds past
midnight. When given a timestamp rather than a time it
returns the number of seconds past midnight in the time
portion of the timestamp. When given an interval rather
than a time it returns the number of seconds in the
interval, ignoring any whole days in the interval.
This function is useful for the analysis of
intervals.