Re: [BUGS] BUG #8216: TO_DATE does not support th format provided

2013-06-07 Thread Tom Lane
sunitha.mudu...@blss.com.au writes: > To_date does not throw an error when an invalid date is provided to it > select to_date('10-30-2012','dd-MM-'); That's not a bug; it's operating as designed. If you want more error checking, don't use to_date() --- just cast the string to date. regressio

[BUGS] BUG #8216: TO_DATE does not support th format provided

2013-06-06 Thread sunitha . mudumba
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 provide