to_date

Converts string to date according to the given format.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: formatting
group label: 数据类型格式化函数
lang: en
layout: table-new
pages: functions-formatting.html
prose only: false

Definition PG 18

Converts string to date according to the given format.

Signatures and overloads

to_date ( text, text ) → date → date

Converts string to date according to the given format.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-formatting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"17b479f1cd22bc7308cefeb2a307da2ef41a0e2864a6ef7d229b93257f07ad97","version":"18.7"},{"file":"functions-formatting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7819c15fc71d5d2494ecc37cbef3fef041440c894a885e853c7e544c631500b4","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:1187901589b51fa6ffc3fa562ecdde8316537f48903f1685be02d70bf2a060dc

Text language: en · wiki-repair-20261023:1187901589b51fa6ffc3fa562ecdde8316537f48903f1685be02d70bf2a060dc