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.