SecondsSinceFromTimestamp function
Returns the number of seconds between two time stamp objects.
Namespace
datetime
Input
timestamp(timestamp
|string
), timestamp base(timestamp
|string
)
Output
second(int
)
Example
If timestamp
contains the time stamp 2008–08–18 22:30:52
, and basetimestamp
contains the timestamp 2008–08–19 22:30:52
, then the two following functions are equivalent, and return the value -86400
:
set-column result datetime:SecondsSinceFromTimestamp('2008–08–18 22:30:52', '2008–08–19 22:30:52')
set-column result datetime:SecondsSinceFromTimestamp(timestamp, basetimestamp)
Created in 2020 by Google Inc.