Postgres Pro
Downloads
Home   >   mailing lists

Re: date function bug - Mailing list pgsql-general

From Ron
Subject Re: date function bug
Date
Msg-id 1629fd7f-af28-62ad-4dac-4e60ad981b41@gmail.com
Whole thread Raw
In response to Re: date function bug  (Ravi Krishna <sr_krishna@aol.com>)
List pgsql-general
Tree view
On 10/23/19 9:32 AM, Ravi Krishna wrote:

> postgres=# select to_date('2018150X','YYYYMMDD');
  > to_date
------------
> 2019-03-03


> postgres=# select to_date('20181501','YYYYMMDD');
>  to_date
> ------------
  > 2019-03-03

is this a cut-n-paste mistake?

Nope.

Here's the screen print: http://i.imgur.com/f0UXfZh.png

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: RE: Re: date function bug
Next
From: Kevin Brannen
Date:
Subject: RE: date function bug