| From: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | to_timestamp TZH and TZM format specifiers |
| Date: | 2018-01-03 18:03:01 |
| Message-ID: | 35eebd0e-ace6-7009-9528-e3646f53f380@2ndQuadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
This small and simple standalone patch extracted from the SQL/JSON work
would allow the user to supply a string with a time zone specified as
hh:mm thus:
SELECT to_timestamp('2011-12-18 11:38 -05:20', 'YYYY-MM-DD HH12:MI
TZH:TZM');
to_timestamp
------------------------------
Sun Dec 18 08:58:00 2011 PST
The patch seems pretty straightforward to me, and it's required for the
jsonpath patches which would be the next cab off the rank in the
SQL/JSON work.
It seems like something worth having quite independently of the SQL/JSON
stuff anyway.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-add-TZH-and-TZM-datetime-template-patterns-v06.patch | text/x-patch | 7.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-01-03 18:03:39 | Re: pgsql: Add parallel-aware hash joins. |
| Previous Message | Bruce Momjian | 2018-01-03 17:49:39 | Re: Speeding up pg_upgrade |