Thread: difference in extract and to_char

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