Copy as Markdown[Open in ChatGPT](https://chatgpt.com/?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fdataprime%2Flanguage-reference%2Ffunctions-reference%2Ftime%2Fextracttime.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)[Open in Claude](https://claude.ai/new?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fdataprime%2Flanguage-reference%2Ffunctions-reference%2Ftime%2Fextracttime.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)

# `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](https://coralogix.com/docs/docs/dataprime/language-reference/functions-reference/.md),<!-- --> **function** and **method**. These interchangeable forms allow flexibility in how you structure expressions.

* Function notation
* Method notation

```
extractTime(timestamp: timestamp, unit: dateunit | timeunit, tz?: string): number
```

```
(timestamp: timestamp).extractTime(unit: dateunit | timeunit, tz?: string): number
```

## 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 1

**Use case: Find the hour in a specific time zone**

Extract the hour of the day from a timestamp, adjusted to Tokyo time.

### Example data

```
{

  "timestamp": 1728636298

}
```

### Example query

* Function notation
* Method notation

```
choose extractTime($m.timestamp, 'h', 'Asia/Tokyo') as h
```

```
choose $m.timestamp.extractTime('h', 'Asia/Tokyo') as h
```

### Example output

```
{

  "h": 20

}
```

## Example 2

**Use case 2: Extract the number of seconds**

Extract just the seconds portion of a timestamp.

### Example data

```
{

  "timestamp": 1728636298

}
```

### Example query

* Function notation
* Method notation

```
choose extractTime(timestamp, 'second') as s
```

```
choose timestamp.extractTime('second') as s
```

### Example output

```
{

  "s": 13.0

}
```