Search Postgresql Archives

Re: date function bug

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: date function bug
From: Ravi Krishna <sr_krishna@xxxxxxx>
Date: Wed, 23 Oct 2019 10:55:34 -0400
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <DM6PR19MB3451B74FE5D084C0B2F08612A46B0@DM6PR19MB3451.namprd19.prod.outlook.com>
References: <0bac35bcde6747e485bc7468c4080798@phx-exmbprd-01.adprod.bmc.com> <a4d04d62-f166-7b91-6e0a-66e06864c2c0@gmail.com> <1793586722.3867823.1571841150028@mail.yahoo.com> <DM6PR19MB3451B74FE5D084C0B2F08612A46B0@DM6PR19MB3451.namprd19.prod.outlook.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: date function bug
  - From: Adrian Klaver

References:
- date function bug
  - From: Abraham, Danny
- Re: date function bug
  - From: Ron
- Re: date function bug
  - From: Ravi Krishna
- RE: date function bug
  - From: Kevin Brannen

Prev by Date: Re: date function bug
Next by Date: Re: Calling jsonb_array_elements 4 times in the same query
Previous by thread: RE: date function bug
Next by thread: Re: date function bug
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux