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 65E4A378-AC45-4157-B59B-026B132B1A43@aol.com
Whole thread Raw
In response to RE: date function bug  (Kevin Brannen <KBrannen@efji.com>)
Responses Re: date function bug
List pgsql-general
Tree view 
>
> ====================
>
> Surprisingly (to me), no….
>
> db=# select to_date('20181501','YYYYMMDD');
>  to_date
> ------------
> 2019-03-03

The above fails in 11.5     SQL Error [22008]: ERROR: date/time field value out of range: "20181501"

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: date function bug
Next
From: Alexander Farber
Date:
Subject: Re: Calling jsonb_array_elements 4 times in the same query