diff options
author | Alexander Korotkov <akorotkov@postgresql.org> | 2019-09-25 21:44:48 +0300 |
---|---|---|
committer | Alexander Korotkov <akorotkov@postgresql.org> | 2019-09-25 22:51:29 +0300 |
commit | 1a950f37d0a283f2a76bec63c05530ed6eb16de1 (patch) | |
tree | b6f65933bb95ac6fdba3a3381dadf779418454d6 /src/backend/utils/adt/jsonpath_exec.c | |
parent | bd29cc1992df9a1b786ca36c05e8f590d3795d10 (diff) | |
download | postgresql-1a950f37d0a283f2a76bec63c05530ed6eb16de1.tar.gz postgresql-1a950f37d0a283f2a76bec63c05530ed6eb16de1.zip |
Implement standard datetime parsing mode
SQL Standard 2016 defines rules for handling separators in datetime template
strings, which are different to to_date()/to_timestamp() rules. Standard
allows only small set of separators and requires strict matching for them.
Standard applies to jsonpath .datetime() method and CAST (... FORMAT ...) SQL
clause. We're not going to change handling of separators in existing
to_date()/to_timestamp() functions, because their current behavior is familiar
for users. Standard behavior now available by special flag, which will be used
in upcoming .datetime() jsonpath method.
Discussion: https://postgr.es/m/CAPpHfdsZgYEra_PeCLGNoXOWYx6iU-S3wF8aX0ObQUcZU%2B4XTw%40mail.gmail.com
Author: Alexander Korotkov
Diffstat (limited to 'src/backend/utils/adt/jsonpath_exec.c')
0 files changed, 0 insertions, 0 deletions