Date functions

These are all the functions defined in the date module:

to_text

Converts a date into a text.
Since there are many possible date representations, to_text takes a format parameter that describes thanks to specifiers how the date or timestamp should be structured.

prql target:sql.duckdb

from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SELECT
  strftime(invoice_date, '%d/%m/%Y')
FROM
  invoices

prql target:sql.postgres

from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SELECT
  TO_CHAR(invoice_date, 'DD/MM/YYYY')
FROM
  invoices

prql target:sql.mysql

from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SELECT
  DATE_FORMAT(invoice_date, '%d/%m/%Y')
FROM
  invoices

Date & time format specifiers

PRQL specifiers for date and time formatting is a subset of specifiers used by chrono.

Here is the list of the specifiers currently supported: