]> granicus.if.org Git - postgresql/commit
Implement parse_datetime() function
authorAlexander Korotkov <akorotkov@postgresql.org>
Wed, 25 Sep 2019 18:50:55 +0000 (21:50 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Wed, 25 Sep 2019 19:51:51 +0000 (22:51 +0300)
commit66c74f8b6e347ba5830bf06468bef8081601c187
tree135fdee4a1d7abfa91861e76470af23737083d4c
parent1a950f37d0a283f2a76bec63c05530ed6eb16de1
Implement parse_datetime() function

This commit adds parse_datetime() function, which implements datetime
parsing with extended features demanded by upcoming jsonpath .datetime()
method:

 * Dynamic type identification based on template string,
 * Support for standard-conforming 'strict' mode,
 * Timezone offset is returned as separate value.

Extracted from original patch by Nikita Glukhov, Teodor Sigaev, Oleg Bartunov.
Revised by me.

Discussion: https://postgr.es/m/fcc6fc6a-b497-f39a-923d-aa34d0c588e8%402ndQuadrant.com
Discussion: https://postgr.es/m/CAPpHfdsZgYEra_PeCLGNoXOWYx6iU-S3wF8aX0ObQUcZU%2B4XTw%40mail.gmail.com
Author: Nikita Glukhov, Teodor Sigaev, Oleg Bartunov, Alexander Korotkov
Reviewed-by: Anastasia Lubennikova, Peter Eisentraut
src/backend/utils/adt/date.c
src/backend/utils/adt/formatting.c
src/include/utils/date.h
src/include/utils/formatting.h