>> AFAIK it's a known issue with no easy solution. I think the only >> workarounds have involved > fiddling with the timezone to fudge things. > > Oh, bother. I was hoping that my use case was common enough that there was > an option I was just missing. > > So it looks like I have to set TZ=UTC and munge the timestamps on insert > so > that when I insert at (say) 5:00PM PDT I'm actually inserting 5:00PM UTC. > Handling Daylight Saving will be a pain, though - I'll have to switch > between UTC and UTC+1 (or UTC-1) when generating charts depending on the > day > of the year.
The problem with that: ... 05:57 05:58 05:59 05:00 05:01 05:02 ... When DST ends, one hour is repeated. Similarly one hour is missing when DST kicks in. You can't change timezone halfway a graph, so this will bite you two days in a year. Don't know, didn't test this, just as an idea: Would it work to create an artificial timezone which is similar to the British timezone, but DST happening at 5am on the American days? alex _______________________________________________ rrd-users mailing list rrd-users@lists.oetiker.ch https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users