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

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.

On Mon, Mar 26, 2001 at 03:43:49PM +0700, Dmitry Gercog wrote:
> 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'!!!

 Fixed in 7.1.

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz