# EXTRACT

Extracts a unit of time as a field from the given timestamp.

## Syntax

```
EXTRACT(FIELD FROM X)
```

## Arguments

#### FIELD

Type: `identifier`

The unit of time to extract.

The following fields are supported:

| Field | Description |
| --- | --- |
| `YEAR` | year |
| `QUARTER` | quarter |
| `MONTH` | month |
| `WEEK` | week |
| `DAY` | day |
| `DAY_OF_MONTH` | day |
| `DAY_OF_WEEK` | day of week |
| `DOW` | day of week |
| `DAY_OF_YEAR` | day of year |
| `DOY` | day of year |
| `YEAR_OF_WEEK` | year of week |
| `YOW` | year of week |
| `HOUR` | hour |
| `MINUTE` | minute |
| `SECOND` | second |

#### X

Type: `timestamp`

The time to extract `FIELD` from.

## Returns

Type: `bigint`

The `FIELD` extracted from `X`.

***

## Examples

| Field | X | Output |
| --- | --- | --- |
| year | `2012-02-22 00:00:00` | 2012 |
| month | `2012-02-22 00:00:00` | 02 |
| day | `2012-02-22 00:00:00` | 22 |
| hour | `2012-02-22 00:00:00` | 01 |
| minute | `2012-02-22 01:02:00` | 02 |
| second | `2012-02-22 01:00:32` | 21 |
| dow | `2012-02-22 01:00:32` | 3 |
| dow | `null` | `null` |