Re: Document DateStyle effect on jsonpath string()

On Sep 10, 2024, at 16:10, Peter Eisentraut  wrote:

> These JSON path functions are specified by the SQL standard, so they shouldn't depend on PostgreSQL-specific settings.  At least in new functionality we should avoid that, no?

Does that also apply to `datetime(template)`, where it uses the `to_timestamp()` templates? From the docs[1]:

> The datetime() and datetime(template) methods use the same parsing rules as the to_timestamp SQL function does (see Section 9.8[2]), with three exceptions. First, these methods don't allow unmatched template patterns. Second, only the following separators are allowed in the template string: minus sign, period, solidus (slash), comma, apostrophe, semicolon, colon and space. Third, separators in the template string must exactly match the input string.

Does the standard specify a formatting language?

Best,

David

[1]: https://www.postgresql.org/docs/devel/functions-json.html
[2]: https://www.postgresql.org/docs/devel/functions-formatting.html