extractTime
Description
Returns a specific unit of time extracted from a timestamp, such as the hour, minute, or second.
Note
- Date units such as
'month'
or'week'
start from 1, not 0. - Units smaller than
minute
return floating-point numbers; all others return integers.
Syntax
Like many functions in DataPrime, extractTime
supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.
Arguments
Name | Type | Required | Description |
---|---|---|---|
timestamp | timestamp | true | The timestamp to extract from |
unit | dateunit | timeunit | true | The unit of time to extract, in short or long notation |
tz | string | false | A valid time zone string (see Time Zone section for details) |
Example
Use case 1: Find the hour in a specific time zone
Extract the hour of the day from a timestamp, adjusted to Tokyo time.
Output
Theme
Light