[rrd-users] Odd mismatch in fetch results (via Perl/CLI)

[Alex van den Bogaerdt]

> data from my RRD file shows up as like I called fetch with the start/end
> interval shifted one hour back:
>
> Tue Nov 30 23:05:00 2010
> Tue Nov 30 23:10:00 2010
> Tue Nov 30 23:15:00 2010
> ...
> Fri Dec 31 22:55:00 2010
> Fri Dec 31 23:00:00 2010
> Fri Dec 31 23:05:00 2010
>
> This means that I get one hour of NaNs at the top of the report, and one
> hou

[...]

> But this doesn't make sense: if I use "rrdtool fetch" directly from the
> command line and with the same parameters as the script, I get the
> values I expect:
>
> $ rrdtool fetch rrd/t*.rrd AVERAGE -s 1291158000 -e 1293836400 | awk
> '/:/ { print $1 }' | head -n 3
> 1291158300:
> 1291158600:
> 1291158900:
>
> Any ideas?

I have only limited computer access right now, so cannot check on my own
system.

According to http://www.onlineconversion.com/unix_time.htm
1291158000 is 23:00 UTC.
http://www.epochconverter.com/ agrees.

You expected midnight UTC here?