> For the complete documentation index, see [llms.txt](https://docs.rasgoml.com/rasgo-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rasgoml.com/rasgo-docs/rasgo-0.1/all-transforms/datepart.md).

# Datepart

Extracts a specific part of a date column. For example, if the input is '2021-01-01', you can ask for the year and get back 2021.

An exhaustive list of valid date parts can be [found here](https://docs.snowflake.com/en/sql-reference/functions-date-time.html#label-supported-date-time-parts).

## Parameters

| Name  | Type           | Description                                                                                           | Is Optional |
| ----- | -------------- | ----------------------------------------------------------------------------------------------------- | ----------- |
| dates | datepart\_dict | dict where keys are names of columns you want to date part and values are the desired date part grain |             |

## Example

```python
ds = rasgo.get.dataset(id)

ds2 = ds.datepart(dates={
    'DATE_STRING':'year',
    'DATE2_STR':'month'
  })
ds2.preview()

```

## Source Code

{% embed url="<https://github.com/rasgointelligence/RasgoTransforms/blob/main/rasgotransforms/rasgotransforms/transforms/datepart/snowflake/datepart.sql>" %}