Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Tom Lane
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id 8456.1056031822@sss.pgh.pa.us
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  ("Peter Haworth" <pmh@edison.ioppublishing.com>)
Responses Re: A creepy story about dates. How to prevent it?  (nolan@celery.tssi.com)
List pgsql-general
"Peter Haworth" <pmh@edison.ioppublishing.com> writes:
> On Wed, 18 Jun 2003 15:09:44 -0600 (MDT), scott.marlowe wrote:
>> Why not accept a date of 04/44/2003 and just wrap it into May?

> Unbelievably, to_date() already does that in 7.3.3:

It's only "unbelievable" if Oracle doesn't do the same thing.  to_date
and friends are Oracle compatibility functions and are intended to
slavishly imitate what Oracle does, warts and all (and there are
certainly plenty of warts there...)

Anyone care to run some tests to see how lax Oracle's to_date is?

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Incremental backups, and backup history
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: attisdropped, * expansion and tg_trigtuple