MySQL query question.

[cdmn]

Hi there,

i have a table with "timestamp" field and a "bytes send" field.
Im not good with date function in MySQL so please help me if you can :-)

My query should say: "show me how many bytes are send every hour, starting from date #*$!x-xx-xx xx:xx:xx and ending with #*$!x-xx-xx xx:xx:xx".

Thanks in advance! :-)

[phranque]

you could try something like this:

SELECT SUM(bytes_sent), DATE_FORMAT(time_stamp, %Y%m%d%H) AS date_hour FROM table_name WHERE time_stamp > YYYYMMDDHH AND time_stamp < YYYYMMDDHH GROUP BY date_hour

[cdmn]

Brilliant!
I own you one!