Jasen Betts wrote on 18.07.2011 11:23:
postgres=> select to_date('20110231', 'yyyymmdd');to_date ------------ 2011-03-03 (1 row) is there a way to have to_date() raise an exception in such a case?it's possible the odd behaviour you get is required by some standard.
That would be *very* odd indeed.
jasen=# select '20110303'::date;
Thanks for the tip, this was more a question regarding _why_ to_char() behaves this way. Thomas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
