[rrd-users] Re: Date Range

[Alex van den Bogaerdt]

On Mon, Oct 24, 2005 at 05:08:20PM -0500, James Richardson wrote:
> I'm curious, if I query an RRD file for date from 10/15/2005 @ 23:59:59
> to 10/20/2005 @ 23:59:59 I get samples in the result set for both
> 10/15/2005 @ 23:00:00 and 10/21/2005 @ 00:00:00.
> 
> Does anyone know how this could be?

You have hourly data.

The sample containing time 10/15/2005 @ 23:59:59 is the one starting
10/15/2005 @ 23:00:00 and ending 10/16/2005 @ 00:00:00.

The sample containing time 10/20/2005 @ 23:59:59 is the one starting
10/20/2005 @ 23:00:00 and ending 10/21/2005 @ 00:00:00.

Data from 10/20/2005 @ 23:00:00 to 1 hour later is stored in the
sample 10/21/2005 @ 00:00:00.  You do want that sample judging from
your end time.  I do not understand what you are trying to achieve
with your start time.  Most likely, you do not want that sample.

So, if you want exactly 5 days, ask for end time 10/21/2005 @ 00:00:00
and start time 10/16/2005 @ 00:00:00

Apart from this, rrdtool fetch seems to return an extra row (not sure
if this is in all versions) when you select the start time exactly
on the hour.  You may need to alter start time in 00:00:01

HTH
-- 
Alex van den Bogaerdt
http://www.vandenbogaerdt.nl/rrdtool/

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi