Skip to content

Latest commit

 

History

History
66 lines (51 loc) · 3.86 KB

dfr_datepart.md

File metadata and controls

66 lines (51 loc) · 3.86 KB
Raw
title categories version expression usage feature
dfr datepart
expression
0.93.0
Creates an expression for capturing the specified datepart in a column.
Creates an expression for capturing the specified datepart in a column.
dataframe

dfr datepart for expression

Creates an expression for capturing the specified datepart in a column.

::: warning Dataframe commands were not shipped in the official binaries by default, you have to build it with --features=dataframe flag :::

Signature

> dfr datepart {flags} (Datepart name)

Parameters

  • Datepart name: Part of the date to capture. Possible values are year, quarter, month, week, weekday, day, hour, minute, second, millisecond, microsecond, nanosecond

Input/output types:

input output
any any

Examples

Creates an expression to capture the year date part

> [["2021-12-30T01:02:03.123456789"]] | dfr into-df | dfr as-datetime "%Y-%m-%dT%H:%M:%S.%9f" | dfr with-column [(dfr col datetime | dfr datepart year | dfr as datetime_year )]
╭───┬─────────────┬───────────────╮
│ # │  datetime   │ datetime_year │
├───┼─────────────┼───────────────┤
│ 0 │ 2 years ago │          2021 │
╰───┴─────────────┴───────────────╯

Creates an expression to capture multiple date parts

> [["2021-12-30T01:02:03.123456789"]] | dfr into-df | dfr as-datetime "%Y-%m-%dT%H:%M:%S.%9f" |
                dfr with-column [ (dfr col datetime | dfr datepart year | dfr as datetime_year ),
                (dfr col datetime | dfr datepart month | dfr as datetime_month ),
                (dfr col datetime | dfr datepart day | dfr as datetime_day ),
                (dfr col datetime | dfr datepart hour | dfr as datetime_hour ),
                (dfr col datetime | dfr datepart minute | dfr as datetime_minute ),
                (dfr col datetime | dfr datepart second | dfr as datetime_second ),
                (dfr col datetime | dfr datepart nanosecond | dfr as datetime_ns ) ]
╭───┬─────────────┬───────────────┬────────────────┬──────────────┬───────────────┬─────────────────┬─────────────────┬─────────────╮
│ # │  datetime   │ datetime_year │ datetime_month │ datetime_day │ datetime_hour │ datetime_minute │ datetime_second │ datetime_ns │
├───┼─────────────┼───────────────┼────────────────┼──────────────┼───────────────┼─────────────────┼─────────────────┼─────────────┤
│ 0 │ 2 years ago │          2021 │             12 │           30 │             1 │               2 │               3 │   123456789 │
╰───┴─────────────┴───────────────┴────────────────┴──────────────┴───────────────┴─────────────────┴─────────────────┴─────────────╯