pgsql: Support for SSSSS datetime format pattern

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Support for SSSSS datetime format pattern
Date: 2019-09-16 18:16:46
Message-ID: E1i9vYM-0000Pc-WD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Support for SSSSS datetime format pattern

SQL Standard 2016 defines SSSSS format pattern for seconds past midnight in
jsonpath .datetime() method and CAST (... FORMAT ...) SQL clause. In our
datetime parsing engine we currently support it with SSSS name.

This commit adds SSSSS as an alias for SSSS. Alias is added in favor of
upcoming jsonpath .datetime() method. But it's also supported in to_date()/
to_timestamp() as positive side effect.

Discussion: https://postgr.es/m/CAPpHfdsZgYEra_PeCLGNoXOWYx6iU-S3wF8aX0ObQUcZU%2B4XTw%40mail.gmail.com
Author: Nikita Glukhov, Alexander Korotkov
Reviewed-by: Anastasia Lubennikova, Peter Eisentraut

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b64b857f50fb51da1588c54a56f8fc1c0d491058

Modified Files
--------------
doc/src/sgml/func.sgml | 2 +-
src/backend/utils/adt/formatting.c | 12 ++++++++----
src/test/regress/expected/horology.out | 20 ++++++++++++++++++++
src/test/regress/sql/horology.sql | 4 ++++
4 files changed, 33 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2019-09-16 23:03:51 Re: pgsql: Allow setting statistics target for extended statistics
Previous Message Andres Freund 2019-09-16 04:47:52 Re: pgsql: Test pg_atomic_fetch_add_ with variable addend and 16-bit edge c