tabsdata.tableframe.functions.datetime

class ExprDateTimeNameSpace(
expr: ExprDateTimeNameSpace,
)

Bases: object

add_business_days(
n: int | td_typing.IntoExpr,
week_mask: Iterable[bool] = (True, True, True, True, True, False, False),
holidays: Iterable[dt.date] = (),
roll: td_typing.Roll = 'raise',
) → td_expr.Expr
Categories:

date

base_utc_offset() → Expr
Categories:

date

cast_time_unit(
time_unit: Literal['ns', 'us', 'ms'],
) → Expr
Categories:

date

century() → Expr
Categories:

date

combine(
time: time | Expr,
time_unit: Literal['ns', 'us', 'ms'] = 'us',
) → Expr
Categories:

date

convert_time_zone(
time_zone: str,
) → Expr
Categories:

date

date() → Expr
Categories:

date

datetime() → Expr
Categories:

date

day() → Expr
Categories:

date

dst_offset() → Expr
Categories:

date

epoch(
time_unit: Literal['ns', 'us', 'ms', 's', 'd'] = 'us',
) → Expr
Categories:

date

hour() → Expr
Categories:

date

is_leap_year() → Expr
Categories:

date

iso_year() → Expr
Categories:

date

microsecond() → Expr
Categories:

date

millennium() → Expr
Categories:

date

millisecond() → Expr
Categories:

date

minute() → Expr
Categories:

date

month() → Expr
Categories:

date

month_end() → Expr
Categories:

date

month_start() → Expr
Categories:

date

nanosecond() → Expr
Categories:

date

offset_by(
by: str | Expr,
) → Expr
Categories:

date

ordinal_day() → Expr
Categories:

date

quarter() → Expr
Categories:

date

replace(
*,
year: int | td_typing.IntoExpr | None = None,
month: int | td_typing.IntoExpr | None = None,
day: int | td_typing.IntoExpr | None = None,
hour: int | td_typing.IntoExpr | None = None,
minute: int | td_typing.IntoExpr | None = None,
second: int | td_typing.IntoExpr | None = None,
microsecond: int | td_typing.IntoExpr | None = None,
ambiguous: td_typing.Ambiguous | td_expr.Expr = 'raise',
) → td_expr.Expr
replace_time_zone(
time_zone: str | None,
*,
ambiguous: Literal['earliest', 'latest', 'raise', 'null'] | Expr = 'raise',
non_existent: Literal['raise', 'null'] = 'raise',
) → Expr
Categories:

date

second(
*,
fractional: bool = False,
) → Expr
Categories:

date

strftime(
fmt: str,
) → Expr
Categories:

date

time() → Expr
Categories:

date

timestamp(
time_unit: Literal['ns', 'us', 'ms'] = 'us',
) → Expr
Categories:

date

to_string(
fmt: str | None = None,
) → Expr
Categories:

type_casting

total_days() → Expr
Categories:

date

total_hours() → Expr
Categories:

date

total_microseconds() → Expr
Categories:

date

total_milliseconds() → Expr
Categories:

date

total_minutes() → Expr
Categories:

date

total_nanoseconds() → Expr
Categories:

date

total_seconds() → Expr
Categories:

date

truncate(
every: str | timedelta | Expr,
) → Expr
Categories:

date

week() → Expr
Categories:

date

weekday() → Expr
Categories:

date

with_time_unit(
time_unit: Literal['ns', 'us', 'ms'],
) → Expr
Categories:

date

year() → Expr
Categories:

date

ExprDateTimeNameSpace.add_business_days(
n: int | td_typing.IntoExpr,
week_mask: Iterable[bool] = (True, True, True, True, True, False, False),
holidays: Iterable[dt.date] = (),
roll: td_typing.Roll = 'raise',
) → td_expr.Expr
Categories:

date

ExprDateTimeNameSpace.base_utc_offset() → Expr
Categories:

date

ExprDateTimeNameSpace.cast_time_unit(
time_unit: Literal['ns', 'us', 'ms'],
) → Expr
Categories:

date

ExprDateTimeNameSpace.century() → Expr
Categories:

date

ExprDateTimeNameSpace.combine(
time: time | Expr,
time_unit: Literal['ns', 'us', 'ms'] = 'us',
) → Expr
Categories:

date

ExprDateTimeNameSpace.convert_time_zone(
time_zone: str,
) → Expr
Categories:

date

ExprDateTimeNameSpace.date() → Expr
Categories:

date

ExprDateTimeNameSpace.datetime() → Expr
Categories:

date

ExprDateTimeNameSpace.day() → Expr
Categories:

date

ExprDateTimeNameSpace.dst_offset() → Expr
Categories:

date

ExprDateTimeNameSpace.epoch(
time_unit: Literal['ns', 'us', 'ms', 's', 'd'] = 'us',
) → Expr
Categories:

date

ExprDateTimeNameSpace.hour() → Expr
Categories:

date

ExprDateTimeNameSpace.is_leap_year() → Expr
Categories:

date

ExprDateTimeNameSpace.iso_year() → Expr
Categories:

date

ExprDateTimeNameSpace.microsecond() → Expr
Categories:

date

ExprDateTimeNameSpace.millennium() → Expr
Categories:

date

ExprDateTimeNameSpace.millisecond() → Expr
Categories:

date

ExprDateTimeNameSpace.minute() → Expr
Categories:

date

ExprDateTimeNameSpace.month() → Expr
Categories:

date

ExprDateTimeNameSpace.month_end() → Expr
Categories:

date

ExprDateTimeNameSpace.month_start() → Expr
Categories:

date

ExprDateTimeNameSpace.nanosecond() → Expr
Categories:

date

ExprDateTimeNameSpace.offset_by(
by: str | Expr,
) → Expr
Categories:

date

ExprDateTimeNameSpace.ordinal_day() → Expr
Categories:

date

ExprDateTimeNameSpace.quarter() → Expr
Categories:

date

ExprDateTimeNameSpace.replace(
*,
year: int | td_typing.IntoExpr | None = None,
month: int | td_typing.IntoExpr | None = None,
day: int | td_typing.IntoExpr | None = None,
hour: int | td_typing.IntoExpr | None = None,
minute: int | td_typing.IntoExpr | None = None,
second: int | td_typing.IntoExpr | None = None,
microsecond: int | td_typing.IntoExpr | None = None,
ambiguous: td_typing.Ambiguous | td_expr.Expr = 'raise',
) → td_expr.Expr
ExprDateTimeNameSpace.replace_time_zone(
time_zone: str | None,
*,
ambiguous: Literal['earliest', 'latest', 'raise', 'null'] | Expr = 'raise',
non_existent: Literal['raise', 'null'] = 'raise',
) → Expr
Categories:

date

ExprDateTimeNameSpace.second(
*,
fractional: bool = False,
) → Expr
Categories:

date

ExprDateTimeNameSpace.strftime(
fmt: str,
) → Expr
Categories:

date

ExprDateTimeNameSpace.time() → Expr
Categories:

date

ExprDateTimeNameSpace.timestamp(
time_unit: Literal['ns', 'us', 'ms'] = 'us',
) → Expr
Categories:

date

ExprDateTimeNameSpace.to_string(
fmt: str | None = None,
) → Expr
Categories:

type_casting

ExprDateTimeNameSpace.total_days() → Expr
Categories:

date

ExprDateTimeNameSpace.total_hours() → Expr
Categories:

date

ExprDateTimeNameSpace.total_microseconds() → Expr
Categories:

date

ExprDateTimeNameSpace.total_milliseconds() → Expr
Categories:

date

ExprDateTimeNameSpace.total_minutes() → Expr
Categories:

date

ExprDateTimeNameSpace.total_nanoseconds() → Expr
Categories:

date

ExprDateTimeNameSpace.total_seconds() → Expr
Categories:

date

ExprDateTimeNameSpace.truncate(
every: str | timedelta | Expr,
) → Expr
Categories:

date

ExprDateTimeNameSpace.week() → Expr
Categories:

date

ExprDateTimeNameSpace.weekday() → Expr
Categories:

date

ExprDateTimeNameSpace.with_time_unit(
time_unit: Literal['ns', 'us', 'ms'],
) → Expr
Categories:

date

ExprDateTimeNameSpace.year() → Expr
Categories:

date