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.

Info

Since all RDBMS have different ways to format dates and times, PRQL requires an explicit dialect to be specified

Info

For now the supported DBs are: Clickhouse, DuckDB, MySQL, MSSQL and Postgres.

PRQL

prql target:sql.duckdb
from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SQL

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

PRQL

prql target:sql.postgres
from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SQL

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

PRQL

prql target:sql.mysql
from invoices
select {
  invoice_date | date.to_text "%d/%m/%Y"
}

SQL

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:

1

This is different from chrono, for which %f represents nanoseconds