Pggraph

Well there are a few ways to do that, a little bit of JS to read the TZ, and then forward that as part of the request ? pesudo code both client and server side:

get_tz.js:
timezone_get(){
// returns 'America/Edmonton'
return browser.timezone;
}

sever side:
begin;
set tz to 'America/Edmonton';
select * from table where insert_time > now() - '3 hours';
rollback;

That ought to be in the environment too, so I can pick it up from Apache/the CGI directly?

Hmmm, do we want to provide the TZ from the browser, or do we want to provide it from the DB?

I was thinking we wanted to display in the timezone that the user is in.