SecondsSinceFromTimestamp function

Owned by Robin Rielley
Last updated: Jun 16, 2020
1 min read

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.