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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
