Postgres Pro
Downloads
Home   >   mailing lists

Re: date function bug - Mailing list pgsql-general

From Ravi Krishna
Subject Re: date function bug
Date
Msg-id 1866587871.3881806.1571840895790@mail.yahoo.com
Whole thread Raw
In response to date function bug  ("Abraham, Danny" <danny_abraham@bmc.com>)
Responses RE: Re: date function bug
List pgsql-general
Tree view
> 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 by date:

Previous
From: "Abraham, Danny"
Date:
Subject: date function bug
Next
From: Ron
Date:
Subject: Re: date function bug