The following bug has been logged on the website: Bug reference: 8216 Logged by: Sunitha Mudumba Email address: sunitha.mudu...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs