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.