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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org