diff options
| author | Alexander Korotkov | 2019-09-25 18:50:55 +0000 |
|---|---|---|
| committer | Alexander Korotkov | 2019-09-25 19:51:51 +0000 |
| commit | 66c74f8b6e347ba5830bf06468bef8081601c187 (patch) | |
| tree | 135fdee4a1d7abfa91861e76470af23737083d4c /src/include/utils/formatting.h | |
| parent | 1a950f37d0a283f2a76bec63c05530ed6eb16de1 (diff) | |
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
Diffstat (limited to 'src/include/utils/formatting.h')
| -rw-r--r-- | src/include/utils/formatting.h | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/include/utils/formatting.h b/src/include/utils/formatting.h index 0117144779e..beeaf10c332 100644 --- a/src/include/utils/formatting.h +++ b/src/include/utils/formatting.h @@ -26,4 +26,7 @@ extern char *asc_tolower(const char *buff, size_t nbytes); extern char *asc_toupper(const char *buff, size_t nbytes); extern char *asc_initcap(const char *buff, size_t nbytes); +extern Datum parse_datetime(text *date_txt, text *fmt, bool std, + Oid *typid, int32 *typmod, int *tz); + #endif |