| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Nick Davies <Nick(dot)Davies(at)iliad-solutions(dot)com> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: FF3 vs MS Date/Time Template - ERROR: date/time field value out of range |
| Date: | 2024-12-07 17:49:45 |
| Message-ID: | 3281202.1733593785@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Nick Davies <Nick(dot)Davies(at)iliad-solutions(dot)com> writes:
> In the docs it appears the 'MS' and 'FF3' date time template patterns are identical but the behaviour is different. We also support Oracle which doesn't have 'MS', so we tried to use the pattern 'YYYYMMDDHH24MISSFF3'. This doesn't work, but switching to 'MS' does.
Thanks for the report! The problem seems to be that the FFn codes are
mislabeled with is_digit = false. That causes the preceding SS code
to think that it should eat all the remaining digits, so we end with
seconds = 33123 which of course results in an error.
I went through the other format codes to look for similar errors and
didn't see any.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| fix-FF-is_digit-labeling.patch | text/x-diff | 4.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2024-12-08 10:37:36 | Re: BUG #18735: Specific multibyte character in psql file path command parameter for Windows |
| Previous Message | Robins Tharakan | 2024-12-07 11:42:07 | Re: Build failure with GCC 15 (defaults to -std=gnu23) |