TimeOffsetByComponents function
Returns the time, with offsets applied from the base time with hour offset, minute offset, and second offset, each given as separate values.
Namespace
datetime
Input
time(time
|string
), hours offset(int
), minutes offset(int
), seconds offset(int
)
Output
time(time
)
Example
If basetime
contains 14:05:29
and hoursoffset
contains the value 2
, minutesoffset
contains the value 0
, secondsoffset
contains the value 20
, then the two following functions are equivalent, and return the time 16:05:49
set-column result datetime:TimeOffsetByComponents('14:05:29', 2, 0, 20)
set-column result datetime:TimeOffsetByComponents('14:05:29', 2, 0, 20)
Created in 2020 by Google Inc.