to_date() accepts wrong input data - Mailing list pgsql-general

From Andreas Kretschmer
Subject to_date() accepts wrong input data
Date
Msg-id 20121017141958.GA14897@tux
Whole thread Raw
Responses Re: to_date() accepts wrong input data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I'm a little bit astonished:

test=*# select to_date('2012/30/03','yyyy/mm/dd');
  to_date
------------
 2014-06-07
(1 row)

test=*# select to_date('2013/02/29','yyyy/mm/dd');
  to_date
------------
 2013-03-01
(1 row)


Bug or feature? Version is 9.2.0



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-general by date:

Previous
From: Fathi Ben Nasr
Date:
Subject: Re: PostgreSQL Magazine
Next
From: Tom Lane
Date:
Subject: Re: to_date() accepts wrong input data