Skip site navigation (1) Skip section navigation (2)

Re: to_date() accepts wrong input data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_date() accepts wrong input data
Date: 2012-10-17 14:31:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> 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

Feature, I'm afraid --- people are used to that behavior, see eg

If you want tighter checking, don't use to_date, use the regular
datetime input functions (eg, via a cast to date or timestamp).

			regards, tom lane

In response to

pgsql-general by date

Next:From: Chris AngelicoDate: 2012-10-17 14:42:38
Subject: Re: PostgreSQL training recommendations?
Previous:From: Andreas KretschmerDate: 2012-10-17 14:19:58
Subject: to_date() accepts wrong input data

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group