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 2minutesoffset contains the value 0secondsoffset 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.