pgsql: Support for ISO 8601 in the jsonpath .datetime() method

2020-09-29 Thread Alexander Korotkov
Support for ISO 8601 in the jsonpath .datetime() method The SQL standard doesn't require jsonpath .datetime() method to support the ISO 8601 format. But our to_json[b]() functions convert timestamps to text in the ISO 8601 format in the sake of compatibility with javascript. So, we add support o

pgsql: Support for ISO 8601 in the jsonpath .datetime() method

2020-09-29 Thread Alexander Korotkov
Support for ISO 8601 in the jsonpath .datetime() method The SQL standard doesn't require jsonpath .datetime() method to support the ISO 8601 format. But our to_json[b]() functions convert timestamps to text in the ISO 8601 format in the sake of compatibility with javascript. So, we add support o