Re: date function bug

From: Ravi Krishna <sr_krishna(at)aol(dot)com>
To: danny_abraham(at)bmc(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: date function bug
Date: 2019-10-23 14:28:15
Message-ID: 1866587871.3881806.1571840895790@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-10-23 14:28:48 Re: date function bug
Previous Message Abraham, Danny 2019-10-23 14:22:31 date function bug