RE: Re: date function bug
От
Abraham, Danny
Тема
RE: Re: date function bug
Дата
Msg-id
948520b28c3245d8ba4f0c622a50a851@phx-exmbprd-01.adprod.bmc.com
Ответ на
Re: date function bug (Ravi Krishna)
Список
Дерево обсуждения
date function bug "Abraham, Danny" <danny_abraham@bmc.com>
Re: date function bug Ravi Krishna <sr_krishna@aol.com>
RE: Re: date function bug "Abraham, Danny" <danny_abraham@bmc.com>
Re: date function bug Tom Lane <tgl@sss.pgh.pa.us>
Re: date function bug Adrian Klaver <adrian.klaver@aklaver.com>
Re: date function bug Ron <ronljohnsonjr@gmail.com>
Re: date function bug Ravi Krishna <sr_krishna@aol.com>
Re: date function bug Ron <ronljohnsonjr@gmail.com>
RE: date function bug Kevin Brannen <KBrannen@efji.com>
Re: date function bug Ravi Krishna <sr_krishna@aol.com>
Re: date function bug Adrian Klaver <adrian.klaver@aklaver.com>
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@aol.com>
Sent: Wednesday, October 23, 2019 5:28 PM
To: Abraham, Danny <danny_abraham@bmc.com>; pgsql-general@postgresql.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.
В списке pgsql-general по дате отправления
