BUG #8216: TO_DATE does not support th format provided - Mailing list pgsql-bugs

From sunitha.mudumba@blss.com.au
Subject BUG #8216: TO_DATE does not support th format provided
Date
Msg-id E1Ukmke-0008Rf-AX@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8216: TO_DATE does not support th format provided
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8216
Logged by:          Sunitha Mudumba
Email address:      sunitha.mudumba@blss.com.au
PostgreSQL version: 9.2.4
Operating system:   Windows
Description:        =


To_date does not throw an error when an invalid date is provided to it
select to_date('10-30-2012','dd-MM-YYYY');

It is not forcing the format on the date,  instead it stores 2014-06-14.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #8215: pg_dump includes table out of order in SQL dump
Next
From: Federico Campoli
Date:
Subject: Re: BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica