Date & Time

Construct, extract, and transform dates, times, timestamps, durations, and periods.

Scalar Functions

Function	Summary
`spql.dt.ceil`	Ceil a temporal value to a fixed frequency in its local clock.
`spql.dt.current_date`	Return the current UTC date.
`spql.dt.current_time`	Return the current UTC time of day.
`spql.dt.current_timestamp`	Return the current UTC timestamp.
`spql.dt.day`	Extract the calendar day of month.
`spql.dt.day_of_week`	Extract the zero-based weekday where Monday is 0.
`spql.dt.day_of_year`	Extract the one-based day of year.
`spql.dt.duration_components`	Split a duration into day-time components.
`spql.dt.duration_total`	Return a duration total in the requested unit.
`spql.dt.floor`	Floor a temporal value to a fixed frequency in its local clock.
`spql.dt.format`	Format local calendar fields with a strftime-like pattern.
`spql.dt.from_epoch`	Convert an epoch count into a timestamp in the requested unit.
`spql.dt.hour`	Extract the hour of day.
`spql.dt.is_leap_year`	Return whether the date belongs to a leap year.
`spql.dt.is_month_end`	Return whether the date is the last day of its month.
`spql.dt.is_month_start`	Return whether the date is the first day of its month.
`spql.dt.is_quarter_end`	Return whether the date ends a quarter.
`spql.dt.is_quarter_start`	Return whether the date starts a quarter.
`spql.dt.is_year_end`	Return whether the date ends a year.
`spql.dt.is_year_start`	Return whether the date starts a year.
`spql.dt.iso_day`	Extract the ISO weekday where Monday is 1.
`spql.dt.iso_week`	Extract the ISO week number.
`spql.dt.iso_year`	Extract the ISO week-numbering year.
`spql.dt.local_time`	Return the current local time of day.
`spql.dt.local_timestamp`	Return the current local timestamp.
`spql.dt.minute`	Extract the minute of hour.
`spql.dt.month`	Extract the calendar month.
`spql.dt.parse_date`	Parse text as a calendar date.
`spql.dt.parse_duration`	Parse a fixed elapsed duration.
`spql.dt.parse_period`	Parse text as a regular calendar period.
`spql.dt.parse_time`	Parse text as a time of day.
`spql.dt.parse_timestamp`	Parse text as a timestamp.
`spql.dt.period_bounds`	Return half-open date bounds for a period string.
`spql.dt.period_end`	Return the exclusive end date of a period.
`spql.dt.period_start`	Return the inclusive start date of a period.
`spql.dt.quarter`	Extract the calendar quarter.
`spql.dt.round`	Round a temporal value to a fixed frequency in its local clock.
`spql.dt.second`	Extract the second of minute.
`spql.dt.to_date`	Convert a timestamp's local date or a period to a calendar date.
`spql.dt.to_duration`	Convert a time of day to an elapsed duration since midnight.
`spql.dt.to_epoch`	Convert a temporal value into an epoch count.
`spql.dt.to_period`	Convert a date, local timestamp, or period to a regular calendar period.
`spql.dt.to_time`	Convert a timestamp to its local time of day.
`spql.dt.to_timestamp`	Convert a date or period to a timestamp at midnight.
`spql.dt.trunc`	Truncate a temporal value to a local calendar or clock part.
`spql.dt.tz_convert`	Change an already-zoned timestamp to another timezone, preserving its instant and unit.
`spql.dt.tz_localize`	Localize civil timestamps, preserving units. Reject skipped and, by default, repeated times.
`spql.dt.year`	Extract the calendar year.

`spql.dt.ceil`

Ceil a temporal value to a fixed frequency in its local clock.

Kind: scalar function
Volatility: immutable

spql.dt.ceil(value, 'freq') -> inferred

The result type and nullability are inferred from the argument types when the call is bound.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration`	Temporal value to inspect, convert or format.
`freq`	yes	`utf8?`	Bind-time fixed frequency.

`spql.dt.current_date`

Return the current UTC date.

Kind: scalar function
Volatility: volatile

spql.dt.current_date() -> vortex.date

The system clock is sampled once per input batch. Values may differ between batches and between executions of a reused plan.

Parameters

No parameters.

`spql.dt.current_time`

Return the current UTC time of day.

Kind: scalar function
Volatility: volatile

spql.dt.current_time() -> vortex.time

The system clock is sampled once per input batch. Values may differ between batches and between executions of a reused plan.

Parameters

No parameters.

`spql.dt.current_timestamp`

Return the current UTC timestamp.

Kind: scalar function
Volatility: volatile

spql.dt.current_timestamp() -> vortex.timestamp

The system clock is sampled once per input batch. Values may differ between batches and between executions of a reused plan.

Parameters

No parameters.

`spql.dt.day`

Extract the calendar day of month.

Kind: scalar function
Volatility: immutable

spql.dt.day(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.day_of_week`

Extract the zero-based weekday where Monday is 0.

Kind: scalar function
Volatility: immutable

spql.dt.day_of_week(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.day_of_year`

Extract the one-based day of year.

Kind: scalar function
Volatility: immutable

spql.dt.day_of_year(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.duration_components`

Split a duration into day-time components.

Kind: scalar function
Volatility: immutable

spql.dt.duration_components(value) -> struct { days: i64?, hours: i64?, minutes: i64?, seconds: i64?, nanoseconds: i64? }?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`spql.Duration`	Temporal value to inspect, convert or format.

`spql.dt.duration_total`

Return a duration total in the requested unit.

Kind: scalar function
Volatility: immutable

spql.dt.duration_total(value, 'unit') -> i64?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`spql.Duration`	Temporal value to inspect, convert or format.
`unit`	yes	`utf8?`	Bind-time output unit.

`spql.dt.floor`

Floor a temporal value to a fixed frequency in its local clock.

Kind: scalar function
Volatility: immutable

spql.dt.floor(value, 'freq') -> inferred

The result type and nullability are inferred from the argument types when the call is bound.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration`	Temporal value to inspect, convert or format.
`freq`	yes	`utf8?`	Bind-time fixed frequency.

`spql.dt.format`

Format local calendar fields with a strftime-like pattern.

Kind: scalar function
Volatility: immutable

spql.dt.format(value, 'format') -> utf8?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration \| spql.Period`	Temporal value to inspect, convert or format.
`format`	yes	`utf8?`	Bind-time strftime-like pattern.

`spql.dt.from_epoch`

Convert an epoch count into a timestamp in the requested unit.

Kind: scalar function
Volatility: immutable

spql.dt.from_epoch(value, 'unit') -> vortex.timestamp?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Parameters

Name	Required	Type	Description
`value`	yes	`i64?`	Signed epoch offset in the selected unit.
`unit`	yes	`utf8?`	Bind-time timestamp unit: `s`, `ms`, `us`, or `ns`.

Returns

A timestamp that uses the requested unit.

`spql.dt.hour`

Extract the hour of day.

Kind: scalar function
Volatility: immutable

spql.dt.hour(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.time \| vortex.timestamp`	Temporal value to inspect, convert or format.

`spql.dt.is_leap_year`

Return whether the date belongs to a leap year.

Kind: scalar function
Volatility: immutable

spql.dt.is_leap_year(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_month_end`

Return whether the date is the last day of its month.

Kind: scalar function
Volatility: immutable

spql.dt.is_month_end(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_month_start`

Return whether the date is the first day of its month.

Kind: scalar function
Volatility: immutable

spql.dt.is_month_start(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_quarter_end`

Return whether the date ends a quarter.

Kind: scalar function
Volatility: immutable

spql.dt.is_quarter_end(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_quarter_start`

Return whether the date starts a quarter.

Kind: scalar function
Volatility: immutable

spql.dt.is_quarter_start(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_year_end`

Return whether the date ends a year.

Kind: scalar function
Volatility: immutable

spql.dt.is_year_end(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.is_year_start`

Return whether the date starts a year.

Kind: scalar function
Volatility: immutable

spql.dt.is_year_start(value) -> bool?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.iso_day`

Extract the ISO weekday where Monday is 1.

Kind: scalar function
Volatility: immutable

spql.dt.iso_day(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.iso_week`

Extract the ISO week number.

Kind: scalar function
Volatility: immutable

spql.dt.iso_week(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.iso_year`

Extract the ISO week-numbering year.

Kind: scalar function
Volatility: immutable

spql.dt.iso_year(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.local_time`

Return the current local time of day.

Kind: scalar function
Volatility: volatile

spql.dt.local_time() -> vortex.time

The system clock is sampled once per input batch. Values may differ between batches and between executions of a reused plan.

Parameters

No parameters.

`spql.dt.local_timestamp`

Return the current local timestamp.

Kind: scalar function
Volatility: volatile

spql.dt.local_timestamp() -> vortex.timestamp

The system clock is sampled once per input batch. Values may differ between batches and between executions of a reused plan.

Parameters

No parameters.

`spql.dt.minute`

Extract the minute of hour.

Kind: scalar function
Volatility: immutable

spql.dt.minute(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.time \| vortex.timestamp`	Temporal value to inspect, convert or format.

`spql.dt.month`

Extract the calendar month.

Kind: scalar function
Volatility: immutable

spql.dt.month(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.parse_date`

Parse text as a calendar date.

Kind: scalar function
Volatility: immutable

spql.dt.parse_date(value, 'format'?, 'errors'?) -> vortex.date?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Null inputs propagate. Coercion handles value errors only. Invalid controls fail binding. Dates use days; times and zone-free timestamps use nanoseconds.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	Text to parse.
`format`	no	`utf8?`	Numeric pattern: %Y, %m, %d, %j, %H, %M, %S, %f, %%. Timezones unsupported.
`errors`	no	`utf8?`	Error policy: raise (default) or coerce (invalid or overflowing values become null).

`spql.dt.parse_duration`

Parse a fixed elapsed duration.

Kind: scalar function
Volatility: immutable

spql.dt.parse_duration(value) -> spql.Duration?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	Duration text such as `2h` or `1500ms`.

`spql.dt.parse_period`

Parse text as a regular calendar period.

Kind: scalar function
Volatility: immutable

spql.dt.parse_period(value, 'freq') -> spql.Period?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	A date or frequency-appropriate period label.
`freq`	yes	`utf8?`	Bind-time period frequency: `D`, `W`, `MS`, `ME`, `QS`, `QE`, `YS`, or `YE`.

`spql.dt.parse_time`

Parse text as a time of day.

Kind: scalar function
Volatility: immutable

spql.dt.parse_time(value, 'format'?, 'errors'?) -> vortex.time?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Null inputs propagate. Coercion handles value errors only. Invalid controls fail binding. Dates use days; times and zone-free timestamps use nanoseconds.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	Text to parse.
`format`	no	`utf8?`	Numeric pattern: %Y, %m, %d, %j, %H, %M, %S, %f, %%. Timezones unsupported.
`errors`	no	`utf8?`	Error policy: raise (default) or coerce (invalid or overflowing values become null).

`spql.dt.parse_timestamp`

Parse text as a timestamp.

Kind: scalar function
Volatility: immutable

spql.dt.parse_timestamp(value, 'format'?, 'errors'?) -> vortex.timestamp?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Null inputs propagate. Coercion handles value errors only. Invalid controls fail binding. Dates use days; times and zone-free timestamps use nanoseconds.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	Text to parse.
`format`	no	`utf8?`	Numeric pattern: %Y, %m, %d, %j, %H, %M, %S, %f, %%. Timezones unsupported.
`errors`	no	`utf8?`	Error policy: raise (default) or coerce (invalid or overflowing values become null).

`spql.dt.period_bounds`

Return half-open date bounds for a period string.

Kind: scalar function
Volatility: immutable

spql.dt.period_bounds(value, 'freq') -> struct { start: vortex.date?, end: vortex.date? }?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`utf8?`	Text to parse as a temporal value.
`freq`	yes	`utf8?`	Bind-time period frequency.

`spql.dt.period_end`

Return the exclusive end date of a period.

Kind: scalar function
Volatility: immutable

spql.dt.period_end(value) -> vortex.date?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.period_start`

Return the inclusive start date of a period.

Kind: scalar function
Volatility: immutable

spql.dt.period_start(value) -> vortex.date?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.quarter`

Extract the calendar quarter.

Kind: scalar function
Volatility: immutable

spql.dt.quarter(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.round`

Round a temporal value to a fixed frequency in its local clock.

Kind: scalar function
Volatility: immutable

spql.dt.round(value, 'freq') -> inferred

The result type and nullability are inferred from the argument types when the call is bound.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration`	Temporal value to inspect, convert or format.
`freq`	yes	`utf8?`	Bind-time fixed frequency.

`spql.dt.second`

Extract the second of minute.

Kind: scalar function
Volatility: immutable

spql.dt.second(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.time \| vortex.timestamp`	Temporal value to inspect, convert or format.

`spql.dt.to_date`

Convert a timestamp's local date or a period to a calendar date.

Kind: scalar function
Volatility: immutable

spql.dt.to_date(value) -> type(value)

Same type and nullability as value.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date`	Temporal value to inspect, convert or format.

spql.dt.to_date(value) -> vortex.date?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.to_duration`

Convert a time of day to an elapsed duration since midnight.

Kind: scalar function
Volatility: immutable

spql.dt.to_duration(value) -> type(value)

Same type and nullability as value.

Parameters

Name	Required	Type	Description
`value`	yes	`spql.Duration`	Temporal value to inspect, convert or format.

spql.dt.to_duration(value) -> spql.Duration?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.time`	Temporal value to inspect, convert or format.

`spql.dt.to_epoch`

Convert a temporal value into an epoch count.

Kind: scalar function
Volatility: immutable

spql.dt.to_epoch(value, 'unit') -> i64?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration`	Temporal value to inspect, convert or format.
`unit`	yes	`utf8?`	Bind-time output unit.

`spql.dt.to_period`

Convert a date, local timestamp, or period to a regular calendar period.

Kind: scalar function
Volatility: immutable

spql.dt.to_period(value, 'freq') -> spql.Period?

Nullable when an argument is nullable; otherwise non-nullable. Literal arguments can refine the result type, including its units, shape or element type.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.
`freq`	yes	`utf8?`	Bind-time period frequency: `D`, `W`, `MS`, `ME`, `QS`, `QE`, `YS`, or `YE`.

`spql.dt.to_time`

Convert a timestamp to its local time of day.

Kind: scalar function
Volatility: immutable

spql.dt.to_time(value) -> type(value)

Same type and nullability as value.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.time`	Temporal value to inspect, convert or format.

spql.dt.to_time(value) -> vortex.time?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.timestamp`	Temporal value to inspect, convert or format.

`spql.dt.to_timestamp`

Convert a date or period to a timestamp at midnight.

Kind: scalar function
Volatility: immutable

spql.dt.to_timestamp(value) -> type(value)

Same type and nullability as value.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.timestamp`	Temporal value to inspect, convert or format.

spql.dt.to_timestamp(value) -> vortex.timestamp?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| spql.Period`	Temporal value to inspect, convert or format.

`spql.dt.trunc`

Truncate a temporal value to a local calendar or clock part.

Kind: scalar function
Volatility: immutable

spql.dt.trunc(value, 'part') -> inferred

The result type and nullability are inferred from the argument types when the call is bound.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.time \| vortex.timestamp \| spql.Duration`	Temporal value to inspect, convert or format.
`part`	yes	`utf8?`	Bind-time temporal part.

`spql.dt.tz_convert`

Change an already-zoned timestamp to another timezone, preserving its instant and unit.

Kind: scalar function
Volatility: immutable

spql.dt.tz_convert(value, 'zone') -> inferred

The result type and nullability are inferred from the argument types when the call is bound. Literal arguments can refine the result type, including its units, shape or element type.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.timestamp`	Temporal value to inspect, convert or format.
`zone`	yes	`utf8?`	Bind-time timezone name.

`spql.dt.tz_localize`

Localize civil timestamps, preserving units. Reject skipped and, by default, repeated times.

Kind: scalar function
Volatility: immutable

spql.dt.tz_localize(value, 'zone', 'ambiguous'?, 'nonexistent'?) -> inferred

The result type and nullability are inferred from the argument types when the call is bound. Literal arguments can refine the result type, including its units, shape or element type.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.timestamp`	Temporal value to inspect, convert or format.
`zone`	yes	`utf8?`	Bind-time timezone name.
`ambiguous`	no	`utf8?`	Repeated-time policy: raise (default), earliest, or latest.
`nonexistent`	no	`utf8?`	Skipped-time policy: raise (default). Other policies are rejected.

`spql.dt.year`

Extract the calendar year.

Kind: scalar function
Volatility: immutable

spql.dt.year(value) -> i32?

Nullable when an argument is nullable; otherwise non-nullable.

Parameters

Name	Required	Type	Description
`value`	yes	`vortex.date \| vortex.timestamp \| spql.Period`	Temporal value to inspect, convert or format.

Found a problem? Edit this page or report an issue.

Scalar FunctionsCopy Anchor Link

spql.dt.ceilCopy Anchor Link

spql.dt.current_dateCopy Anchor Link

spql.dt.current_timeCopy Anchor Link

spql.dt.current_timestampCopy Anchor Link

spql.dt.dayCopy Anchor Link

spql.dt.day_of_weekCopy Anchor Link

spql.dt.day_of_yearCopy Anchor Link

spql.dt.duration_componentsCopy Anchor Link

spql.dt.duration_totalCopy Anchor Link

spql.dt.floorCopy Anchor Link

spql.dt.formatCopy Anchor Link

spql.dt.from_epochCopy Anchor Link

spql.dt.hourCopy Anchor Link

spql.dt.is_leap_yearCopy Anchor Link

spql.dt.is_month_endCopy Anchor Link

spql.dt.is_month_startCopy Anchor Link

spql.dt.is_quarter_endCopy Anchor Link

spql.dt.is_quarter_startCopy Anchor Link

spql.dt.is_year_endCopy Anchor Link

spql.dt.is_year_startCopy Anchor Link

spql.dt.iso_dayCopy Anchor Link

spql.dt.iso_weekCopy Anchor Link

spql.dt.iso_yearCopy Anchor Link

spql.dt.local_timeCopy Anchor Link

spql.dt.local_timestampCopy Anchor Link

spql.dt.minuteCopy Anchor Link

spql.dt.monthCopy Anchor Link

spql.dt.parse_dateCopy Anchor Link

spql.dt.parse_durationCopy Anchor Link

spql.dt.parse_periodCopy Anchor Link

spql.dt.parse_timeCopy Anchor Link

spql.dt.parse_timestampCopy Anchor Link

spql.dt.period_boundsCopy Anchor Link

spql.dt.period_endCopy Anchor Link

spql.dt.period_startCopy Anchor Link

spql.dt.quarterCopy Anchor Link

spql.dt.roundCopy Anchor Link

spql.dt.secondCopy Anchor Link

spql.dt.to_dateCopy Anchor Link

spql.dt.to_durationCopy Anchor Link

spql.dt.to_epochCopy Anchor Link

spql.dt.to_periodCopy Anchor Link

spql.dt.to_timeCopy Anchor Link

spql.dt.to_timestampCopy Anchor Link

spql.dt.truncCopy Anchor Link

spql.dt.tz_convertCopy Anchor Link

spql.dt.tz_localizeCopy Anchor Link

spql.dt.yearCopy Anchor Link

Scalar Functions

`spql.dt.ceil`

`spql.dt.current_date`

`spql.dt.current_time`

`spql.dt.current_timestamp`

`spql.dt.day`

`spql.dt.day_of_week`

`spql.dt.day_of_year`

`spql.dt.duration_components`

`spql.dt.duration_total`

`spql.dt.floor`

`spql.dt.format`

`spql.dt.from_epoch`

`spql.dt.hour`

`spql.dt.is_leap_year`

`spql.dt.is_month_end`

`spql.dt.is_month_start`

`spql.dt.is_quarter_end`

`spql.dt.is_quarter_start`

`spql.dt.is_year_end`

`spql.dt.is_year_start`

`spql.dt.iso_day`

`spql.dt.iso_week`

`spql.dt.iso_year`

`spql.dt.local_time`

`spql.dt.local_timestamp`

`spql.dt.minute`

`spql.dt.month`

`spql.dt.parse_date`

`spql.dt.parse_duration`

`spql.dt.parse_period`

`spql.dt.parse_time`

`spql.dt.parse_timestamp`

`spql.dt.period_bounds`

`spql.dt.period_end`

`spql.dt.period_start`

`spql.dt.quarter`

`spql.dt.round`

`spql.dt.second`

`spql.dt.to_date`

`spql.dt.to_duration`

`spql.dt.to_epoch`

`spql.dt.to_period`

`spql.dt.to_time`

`spql.dt.to_timestamp`

`spql.dt.trunc`

`spql.dt.tz_convert`

`spql.dt.tz_localize`

`spql.dt.year`