I just noticed this fairly silly behaviour:

test=# select to_char(current_date, 'D'), extract(dow from current_date);
  to_char | date_part
---------+-----------
  3       |         2
(1 row)


I guess we can't change that now, but they really should number their 
days from the same base...

Chris



Tue, 14 Oct 2003 14:04:52 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
difference in extract and to_char