↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: SQL/JSON: datetime()

The SQL/JSON path datetime() function in JSON path expressions converts valid date and time formats (e.g. ISO 8601) to their corresponding PostgreSQL type.

For more information, see the JSON path documentation