Thread

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

   Dmitry Gertsog <gda@omnet.ru> — 2001-03-26T08:43:49Z

   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.
   
   

2. Re: date_part('dow', '2001-03-25') ??!

   Karel Zak <zakkr@zf.jcu.cz> — 2001-03-26T13:47:38Z

   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