time and date question

[muitine]

with this i get info recorded from 9AM till 9PM:

SELECT round(sum(sent)/1024/1024) from statistik where name='".$login."' and HOUR(time) > 9 and HOUR(time) < 21;

but if i wan't to get the info from 9PM-9AM (the night traffic)

...and HOUR(time) > 21 and HOUR(time) < 9 doesn't work 🙁

[steved]

Try using:

and HOUR(time) > 21 OR HOUR(time) < 9

[muitine]

that gives me an answer, bet it's definately a WRONG ONE! 🙂 in order of getting ~100 Mbytes, i'm getting ~40000 🙂

[steved]

Well, you probably need to also include the date selection into your query somehow.

[muitine]

yes, that's what i'm doing...
i've tried:

SELECT round(sum(issiusta)/1024/1024) from statistika where vardas='".$login."' and YEAR(data)=".$this_year." and MONTH(data)=".$this_month." and HOUR(laikas) > 21 and HOUR(laikas) < 9;

and

SELECT round(sum(issiusta)/1024/1024) from statistika where vardas='".$login."' and YEAR(data)=".$this_year." and MONTH(data)=".$this_month." and HOUR(laikas) < 9 and HOUR(laikas) > 21;

and even:

SELECT round(sum(issiusta)/1024/1024) from statistika where vardas='".$login."' and YEAR(data)=".$this_year." and MONTH(data)=".$this_month." and ((HOUR(laikas) >= 20 and HOUR(laikas) <= 24) and (HOUR(laikas) > 0 and HOUR(laikas) <=9;

but nothing seems to work :/