Retrieves the date for a datetime column.
Returns:
Examples:
1
2
3
4
5
6
7
8
9
10
11
12
13
14 | >>> import datetime
>>> import daft
>>> from daft.functions import date
>>> df = daft.from_pydict(
... {
... "x": [
... datetime.datetime(2021, 1, 1, 5, 1, 1),
... datetime.datetime(2021, 1, 2, 6, 1, 59),
... datetime.datetime(2021, 1, 3, 7, 2, 0),
... ],
... }
... )
>>> df = df.with_column("date", date(df["x"]))
>>> df.show()
|
╭─────────────────────┬────────────╮
│ x ┆ date │
│ --- ┆ --- │
│ Timestamp[us] ┆ Date │
╞═════════════════════╪════════════╡
│ 2021-01-01 05:01:01 ┆ 2021-01-01 │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 2021-01-02 06:01:59 ┆ 2021-01-02 │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 2021-01-03 07:02:00 ┆ 2021-01-03 │
╰─────────────────────┴────────────╯
(Showing first 3 of 3 rows)
Source code in daft/functions/datetime.py
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49 | def date(expr: Expression) -> Expression:
"""Retrieves the date for a datetime column.
Returns:
Expression: a Date expression
Examples:
>>> import datetime
>>> import daft
>>> from daft.functions import date
>>> df = daft.from_pydict(
... {
... "x": [
... datetime.datetime(2021, 1, 1, 5, 1, 1),
... datetime.datetime(2021, 1, 2, 6, 1, 59),
... datetime.datetime(2021, 1, 3, 7, 2, 0),
... ],
... }
... )
>>> df = df.with_column("date", date(df["x"]))
>>> df.show()
╭─────────────────────┬────────────╮
│ x ┆ date │
│ --- ┆ --- │
│ Timestamp[us] ┆ Date │
╞═════════════════════╪════════════╡
│ 2021-01-01 05:01:01 ┆ 2021-01-01 │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 2021-01-02 06:01:59 ┆ 2021-01-02 │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌┤
│ 2021-01-03 07:02:00 ┆ 2021-01-03 │
╰─────────────────────┴────────────╯
<BLANKLINE>
(Showing first 3 of 3 rows)
"""
return Expression._call_builtin_scalar_fn("date", expr)
|