From: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
---|---|
To: | Ravi Krishna <sr_krishna(at)aol(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
Subject: | RE: Re: date function bug |
Date: | 2019-10-23 14:41:44 |
Message-ID: | 948520b28c3245d8ba4f0c622a50a851@phx-exmbprd-01.adprod.bmc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
20181501 is illegal. Working OK.
ctrlmdb=> select to_date('20181501','YYYYMMDD')
ctrlmdb-> \g
ERROR: date/time field value out of range: "20181501"
From: Ravi Krishna <sr_krishna(at)aol(dot)com>
Sent: Wednesday, October 23, 2019 5:28 PM
To: Abraham, Danny <danny_abraham(at)bmc(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: [EXTERNAL] Re: date function bug
> ctrlmdb=> select to_date('2018100X','YYYYMMDD');
> to_date
------------
>2018-10-01
>(1 row)
I am able to reproduce this in 11.5 It seems PG can take a single digit for Day too.
select to_date('2018109','YYYYMMDD') produces 2018-10-09.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-10-23 14:43:28 | Re: date function bug |
Previous Message | Ravi Krishna | 2019-10-23 14:32:30 | Re: date function bug |