date_part('dow', '2001-03-25') ??! - Mailing list pgsql-bugs

Hi!

Why?

SELECT date_part('dow', '2001-03-24');
return '6'

and

SELECT date_part('dow', '2001-03-25');

return '6', but must be '0'!!!

For last Sunday '2001-03-18' this construction return '0'!

My system SuSe Linux 7.0
PostgreSQL version 7.0.3

When I use system command "date":

date +%w -d '2001-03-25'

I'm get correct result = '0'!

Dmitry Gercog.