Horton
Menu

date_part('dow', '2001-03-25') ??!

Dmitry Gertsog <gda@omnet.ru>

View thread
From: Dmitry Gercog <gda@omnet.ru>
To: pgsql-bugs@postgresql.org
Date: 2001-03-26T08:43:49Z
Lists: 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.