Could you expand a little on how that works?
I am starting to think that I wont be able to get the results I need
without post processing.
Looking at the results:
...
| 2007-01-09 20:02:15 |
| 2007-01-09 20:02:15 |
| 2007-01-09 20:03:20 |
| 2007-01-09 20:08:33 |
| 2007-01-09 20:08:33 |
| 2007-01-09 20:12:19 |
| 2007-01-09 20:18:59 |
| 2007-01-09 20:23:03 |
| 2007-01-09 20:50:11 |
| 2007-01-09 20:50:11 |
| 2007-01-09 20:50:12 |
| 2007-01-09 20:50:12 |
| 2007-01-09 20:50:12 |
| 2007-01-09 20:50:12 |
| 2007-01-10 01:16:09 |
| 2007-01-10 01:18:31 |
| 2007-01-10 03:00:22 |
| 2007-01-10 03:09:23 |
| 2007-01-10 03:12:23 |
| 2007-01-10 03:15:23 |
| 2007-01-10 03:18:23 |
| 2007-01-10 03:30:24 |
(the results are GMT, I need AST, hence the day change)
All I am interested in is returning 24 values so with these results I
would have something like:
...
20 - 14
21 - 0
22 - 0
23 - 0
0 - 0
1 - 2
2 - 0
3 - 6
Is this possible?
On 10 Jan 2007 19:55:09 -0000, Felix Geerinckx
<[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] ("Paul Halliday") wrote in
news:[EMAIL PROTECTED]:
> I am trying to deal with empty values so that I can graph data over a
> 24 hour period without gaps.
Have a look here:
http://forums.mysql.com/read.php?10,133603,133607#msg-133607
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
