# Parse a date or time

Shape / columns

parse, format or decompose dates and times; date arithmetic; time zones

Page: <https://meridian.online/operations/parse-a-date-or-time>

## Status

Runs as a SQL step.

arcform carries it as a `sql:` step today.

## The DuckDB step

parse, truncate and convert zone

```sql
CREATE TEMP TABLE result AS
SELECT strptime('03/02/2026 14:30', '%d/%m/%Y %H:%M') AS parsed,
       date_trunc('month', DATE '2026-02-10') AS month,
       dayname(DATE '2026-02-10') AS weekday,
       strftime(timezone('Australia/Sydney', TIMESTAMPTZ '2026-02-10 00:00:00+00'), '%Y-%m-%d %H:%M') AS sydney;
SELECT * FROM result;
SELECT CASE WHEN ((SELECT parsed = TIMESTAMP '2026-02-03 14:30:00' AND month = DATE '2026-02-01' AND weekday = 'Tuesday' AND sydney = '2026-02-10 11:00' FROM result)) THEN 'as expected' ELSE error('a date did not parse, truncate or convert to Sydney time as expected') END AS verdict;
```

The statement builds its own data.

It needs nothing installed beyond DuckDB itself.

## Variants

- Test a time of day: Test whether the time of day of a value lies between two bounds.
- Build a date from its parts: Make a date, time or timestamp from numbers such as year, month and day, or replace one part of it.
- Convert between date and time types: Move date and time values between a tool's date types, such as legacy and current types.
- [Find the time between two dates](https://meridian.online/operations/parse-a-date-or-time/find-the-time-between-two-dates): Compute the interval or the count of units between two dates or times.
- Set a display format: Change how date and time values are shown without changing the stored values.
- [Work with durations](https://meridian.online/operations/parse-a-date-or-time/work-with-durations): Parse, format, decompose and compute on durations and intervals as values of their own.
- [Convert to and from epoch numbers](https://meridian.online/operations/parse-a-date-or-time/convert-to-and-from-epoch-numbers): Turn a Unix epoch number into a timestamp, or a timestamp into one.
- [Extract a part of a date](https://meridian.online/operations/parse-a-date-or-time/extract-a-part-of-a-date): Take a component such as the year, month, weekday or hour out of a date or time as its own value.
- [Format a date as text](https://meridian.online/operations/parse-a-date-or-time/format-a-date-as-text): Write a date, time or timestamp out as text by a format pattern.
- Date and time function libraries: A tool's whole set of date and time functions, covering parsing, formatting, parts and arithmetic together.
- Get the current date and time: Return the date or timestamp at which the run happens.
- Parse text into a date or time: Turn text into a date, time or timestamp, by a format pattern or by inference.
- [Shift a date by an interval](https://meridian.online/operations/parse-a-date-or-time/shift-a-date-by-an-interval): Add or subtract an amount of time to a date, time or timestamp.
- [Convert between time zones](https://meridian.online/operations/parse-a-date-or-time/convert-between-time-zones): Attach, change or convert the time zone of a timestamp.
- [Round a date down to a unit](https://meridian.online/operations/parse-a-date-or-time/round-a-date-down-to-a-unit): Truncate or bucket a date or time to the start of a unit or a fixed interval.

## What other tools call it

Meridian's classification; an independent blind rating agreed on 86.2% of 312 rows (exact class, version 2).

- Azure Data Factory: [`Date and time functions`](https://learn.microsoft.com/en-us/azure/data-factory/data-flow-date-time-functions) (read 2026-09-27)
- Azure Data Factory: [`Date functions`](https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions) (read 2026-09-27)
- Alteryx Designer: [`DateTime`](https://help.alteryx.com/current/en/designer/tools/parse/datetime-tool.html) (read 2026-09-27)
- Apache DataFusion: [`Time and Date Functions`](https://datafusion.apache.org/user-guide/sql/scalar_functions.html) (read 2026-09-27)
- dbt-utils: [`Date and time functions`](https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros) (read 2026-09-27)
- DuckDB: [`Date Format Functions (family)`](https://duckdb.org/docs/current/sql/functions/dateformat) (read 2026-09-27)
- DuckDB: [`Date Functions (family)`](https://duckdb.org/docs/current/sql/functions/date) (read 2026-09-27)
- DuckDB: [`Date Part Functions (family)`](https://duckdb.org/docs/current/sql/functions/datepart) (read 2026-09-27)
- DuckDB: [`Interval Functions (family)`](https://duckdb.org/docs/current/sql/functions/interval) (read 2026-09-27)
- DuckDB: [`Time Functions (family)`](https://duckdb.org/docs/current/sql/functions/time) (read 2026-09-27)
- DuckDB: [`Timestamp Functions (family)`](https://duckdb.org/docs/current/sql/functions/timestamp) (read 2026-09-27)
- DuckDB: [`Timestamp with Time Zone Functions (family)`](https://duckdb.org/docs/current/sql/functions/timestamptz) (read 2026-09-27)
- Duckle: [`Current Timestamp`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Date Add`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Date Diff`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Epoch Convert`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Extract Part`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Format Date`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Parse Date`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Time Bin`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Timezone Convert`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- Duckle: [`Truncate`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25)
- EasyMorph: [`Make date/time columns`](https://help.easymorph.com/doku.php?id=transformations:makedatetimecolumns) (read 2026-09-27)
- AWS Glue: [`Format timestamp`](https://docs.aws.amazon.com/glue/latest/dg/transforms-format-timestamp.html) (read 2026-09-27)
- AWS Glue: [`MonthName`](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-pyspark-transforms-MonthName.html) (read 2026-09-27)
- AWS Glue: [`To timestamp`](https://docs.aws.amazon.com/glue/latest/dg/transforms-to-timestamp.html) (read 2026-09-27)
- Ibis: [`BetweenTime`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`Date`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateAdd`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateDelta`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateDiff`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateFromYMD`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateNow`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/generic.py) (read 2026-09-27)
- Ibis: [`DateSub`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DateTruncate`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DayOfWeekIndex`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`DayOfWeekName`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractDay`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractDayOfYear`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractEpochSeconds`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractHour`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractIsoYear`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractMicrosecond`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractMillisecond`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractMinute`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractMonth`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractQuarter`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractSecond`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractWeekOfYear`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`ExtractYear`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`IntervalAdd`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`IntervalFloorDivide`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`IntervalFromInteger`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`IntervalMultiply`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`IntervalSubtract`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`Strftime`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`StringToDate`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`StringToTime`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`StringToTimestamp`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`Time`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeAdd`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeDelta`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeDiff`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeFromHMS`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeSub`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimeTruncate`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampAdd`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampBucket`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampDelta`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampDiff`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampFromUNIX`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampFromYMDHMS`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampNow`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/generic.py) (read 2026-09-27)
- Ibis: [`TimestampSub`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- Ibis: [`TimestampTruncate`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/temporal.py) (read 2026-09-27)
- KNIME Analytics Platform: [`Date Modifier`](https://api.hub.knime.com/nodes/*LjEOMsJyCgHOEyLb?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date Rounder`](https://api.hub.knime.com/nodes/*MLgWE0ePIyskKgJJ?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date Shifter`](https://api.hub.knime.com/nodes/*TRyzM68BPCPSFm2H?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date&Time Difference`](https://api.hub.knime.com/nodes/*aH2fTw7aINVnPJQu?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date&Time Format Manager`](https://api.hub.knime.com/nodes/*YWYt5ibqQAa_jpLa?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date&Time Part Extractor`](https://api.hub.knime.com/nodes/*Y7HUng9RndjN31qc?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date&Time to String`](https://api.hub.knime.com/nodes/*R172f45iq6STsZWx?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Date&Time to legacy Date&Time`](https://api.hub.knime.com/nodes/*0Uk7y3_4UI7R8yjM?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Duration (Time-based) to Number`](https://api.hub.knime.com/nodes/*LSdmfw3bvWcDSlm2?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Duration Format Manager`](https://api.hub.knime.com/nodes/*XshuTM7atHkZ33MC?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Duration Part Extractor`](https://api.hub.knime.com/nodes/*CqubuamAlzYoI76y?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Duration to String`](https://api.hub.knime.com/nodes/*mB2RAUPk7GC9iGFn?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Legacy Date&Time to Date&Time`](https://api.hub.knime.com/nodes/*prhDzI0ZZh7WvMOY?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`String to Date&Time`](https://api.hub.knime.com/nodes/*S0CYCPOs6qCN_QYQ?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`String to Duration`](https://api.hub.knime.com/nodes/*pDssMDFTGau1fLQV?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Time Modifier`](https://api.hub.knime.com/nodes/*mMBbrGpdzd0BoF-E?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Time Rounder`](https://api.hub.knime.com/nodes/*7phhn81u4VasQR1D?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Time Shifter`](https://api.hub.knime.com/nodes/*_lj-MFghefR5Hig6?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Time Zone Modifier`](https://api.hub.knime.com/nodes/*TjEOSAwWOTvwy15U?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`UNIX Timestamp to Date&Time`](https://api.hub.knime.com/nodes/*uWOA5VCC8225r1HD?details=full) (read 2026-09-27)
- Apache NiFi: [`Date Manipulation`](https://nifi.apache.org/nifi-docs/expression-language-guide.html) (read 2026-09-27)
- OpenRefine: [`Date functions`](https://openrefine.org/docs/manual/grelfunctions#date-functions) (read 2026-09-27)
- Polars: [`Expr.dt (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/temporal.html) (read 2026-09-27)
- Polars: [`Expr.str: parse dates and times (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/string.html) (read 2026-09-27)
- Polars: [`Functions: temporal constructors (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27)
- Polars: [`SQL functions: Temporal (group)`](https://docs.pola.rs/api/python/stable/reference/sql/functions/temporal.html) (read 2026-09-27)
- Polars: [`business_day_count`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27)
- Polars: [`from_epoch`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27)
- Power Query M: [`Date functions`](https://learn.microsoft.com/en-us/powerquery-m/date-functions) (read 2026-09-27)
- Power Query M: [`DateTime functions`](https://learn.microsoft.com/en-us/powerquery-m/datetime-functions) (read 2026-09-27)
- Power Query M: [`DateTimeZone functions`](https://learn.microsoft.com/en-us/powerquery-m/datetimezone-functions) (read 2026-09-27)
- Power Query M: [`Duration functions`](https://learn.microsoft.com/en-us/powerquery-m/duration-functions) (read 2026-09-27)
- Power Query M: [`Time functions`](https://learn.microsoft.com/en-us/powerquery-m/time-functions) (read 2026-09-27)
- RapidMiner Studio: [`Adjust Date`](https://docs.rapidminer.com/latest/studio/operators/blending/values/adjust_date.html) (read 2026-09-27)
- RapidMiner Studio: [`Date to Nominal`](https://docs.rapidminer.com/latest/studio/operators/blending/attributes/types/date_to_nominal.html) (read 2026-09-27)
- RapidMiner Studio: [`Date to Numerical`](https://docs.rapidminer.com/latest/studio/operators/blending/attributes/types/date_to_numerical.html) (read 2026-09-27)
- RapidMiner Studio: [`Nominal to Date`](https://docs.rapidminer.com/latest/studio/operators/blending/attributes/types/nominal_to_date.html) (read 2026-09-27)
- RapidMiner Studio: [`Numerical to Date`](https://docs.rapidminer.com/latest/studio/operators/blending/attributes/types/numerical_to_date.html) (read 2026-09-27)
- Apache SeaTunnel: [`Time and Date Functions`](https://seatunnel.apache.org/docs/2.3.13/transforms/sql-functions) (read 2026-09-27)
- Tableau Prep: [`Convert Dates`](https://help.tableau.com/current/prep/en-us/prep_clean.htm) (read 2026-09-27)
- Tableau Prep: [`Custom Fiscal Year`](https://help.tableau.com/current/prep/en-us/prep_clean.htm) (read 2026-09-27)
- Tableau Prep: [`Date functions (group)`](https://help.tableau.com/current/prep/en-us/prep_function_reference.htm) (read 2026-09-27)
- Trifacta: [`Date Functions (group)`](https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/date-functions.html) (read 2026-09-27)
- Trifacta: [`Date format`](https://help.alteryx.com/aac/en/trifacta-classic/reference/transformation-reference.html) (read 2026-09-27)
- VisiData: [`type-customdate`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/customdate.py#L22) (read 2026-09-23)
- VisiData: [`type-customdate-selected`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/customdate.py#L23) (read 2026-09-23)
