Re: date function bug

From: Ravi Krishna <sr_krishna(at)aol(dot)com>
To: Kevin Brannen <KBrannen(at)efji(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: date function bug
Date: 2019-10-23 14:55:34
Message-ID: 65E4A378-AC45-4157-B59B-026B132B1A43@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> ====================
>
> 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"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2019-10-23 15:16:18 Re: Calling jsonb_array_elements 4 times in the same query
Previous Message Adrian Klaver 2019-10-23 14:46:03 Re: date function bug