On Tuesday, March 29, 2011 8:33:59 am Steve Crawford wrote: > On 03/29/2011 08:07 AM, Marc Munro wrote: > > 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 > > Based on running the queries in 9.0, it's behavior that has been corrected: > > select to_date('Mon1-13-Tue', 'YYYY-IW-DY'); > ERROR: invalid combination of date conventions > HINT: Do not mix Gregorian and ISO week date conventions in a > formatting template. > > Cheers, > Steve
Yes and no:) test(5432)aklaver=>select to_date('2011-13-MON', 'IYYY-IW-DY'); to_date ------------ 2011-03-28 (1 row) test(5432)aklaver=>select to_date('2011-13-SUN', 'IYYY-IW-DY'); to_date ------------ 2011-03-28 (1 row) -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general