difference in extract and to_char

Started by Christopher Kings-Lynneabout 22 years ago1 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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