Home > mailing lists

to_char() accepting invalid dates? - Mailing list pgsql-sql

From	Thomas Kellerer
Subject	to_char() accepting invalid dates?
Date	July 18, 2011 08:22:49
Msg-id	j00qg6$lvf$1@dough.gmane.org Whole thread Raw
List	pgsql-sql

Tree view

Hi,

I just noticed that to_char() will "accept" invalid dates such as 2011-02-31 and "adjust" them accordingly:

postgres=> select to_date('20110231', 'yyyymmdd');  to_date
------------ 2011-03-03
(1 row)

is there a way to have to_date() raise an exception in such a case?

Regards
Thomas

pgsql-sql by date:

From: Craig Ringer
Date: 14 July 2011, 23:40:33
Subject: Re: Looking for a "show create table " equivalent

From: Jasen Betts
Date: 18 July 2011, 09:30:34
Subject: Re: to_char() accepting invalid dates?

to_char() accepting invalid dates? - Mailing list pgsql-sql

Previous

Next