From: Eric Bergen Date: October 17 2004 1:56am Subject: Re: date time functions don't return not null rows List-Archive: http://lists.mysql.com/mysql/174336 Message-Id: <11b1bd99041016185625780281@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Your tables aren't setup very well. You should google for normalization and 'boyce codd normal form' -Eric On Sat, 16 Oct 2004 22:27:51 +0200, owca wrote: > I'm trying get current week, starting from monday to sunday: > > select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id > from tydzien where to_days(day) between > to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting day*/ and > (to_days(now())- mod(to_days(now()),7))+8 /*ending day ^*/ > order by dzien; > > it works! > the table looks like this: > +------------+------+------+------+------+------+------+------+------+----+ > | day | g15 | g16 | g17 | g18 | g19 | g20 | g21 | g22 | id | > +------------+------+------+------+------+------+------+------+------+----+ > | 1098128298 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | > | 1098473898 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | > | 1098560298 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | > | 1098646698 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | > +------------+------+------+------+------+------+------+------+------+----+ > > but it won't return the rows where any of columns g15, g16 etc has a value. eg > > +------------+------+------+------+------+------+------+------+------+----+ > | day | g15 | g16 | g17 | g18 | g19 | g20 | g21 | g22 | id | > +------------+------+------+------+------+------+------+------+------+----+ > | 1098128298 | NULL | 5561 | NULL | NULL | NULL | NULL | NULL | NULL | 9 | > | 1098473898 | NULL | NULL | NULL | 1111 | NULL | NULL | NULL | NULL | 10 | > | 1098560298 | 2355 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | > +------------+------+------+------+------+------+------+------+------+----+ > > did i something wrong? > -- Eric Bergen eric.bergen@stripped