/
TimeOffsetByComponents function

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)

 

Related content

Created in 2020 by Google Inc.