/
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 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)
Related content
TimeFromComponents function
TimeFromComponents function
Read with this
DaysSinceFromDate function
DaysSinceFromDate function
More like this
Router Transformation (Deprecated)
Router Transformation (Deprecated)
More like this
NGramTransform Spark Compute Analytics (Deprecated)
NGramTransform Spark Compute Analytics (Deprecated)
More like this
Parquet Dynamic Partitioned Dataset Sink (Deprecated)
Parquet Dynamic Partitioned Dataset Sink (Deprecated)
More like this
ORC Dynamic Partitioned Dataset Sink (Deprecated)
ORC Dynamic Partitioned Dataset Sink (Deprecated)
More like this
Created in 2020 by Google Inc.