I'm trying to validate a day of the week, and thought that to_date would do the job for me. But I found a case where it cannot tell the difference between sunday and monday. Is this a bug or intended behaviour?
dev=# select to_date('2011-13-Mon', 'YYYY-IW-DY'); to_date ------------ 2011-03-28 (1 row) dev=# select to_date('2011-13-Sun', 'YYYY-IW-DY'); to_date ------------ 2011-03-28 (1 row) dev=# select to_date('2011-13-Tue', 'YYYY-IW-DY'); to_date ------------ 2011-03-29 (1 row) This is on postgres 8.3.14. __ Marc
signature.asc
Description: This is a digitally signed message part