Project

General

Profile

Feature #4915

insert_time should be timestamptz

Added by Darcy Buskermolen over 15 years ago. Updated over 14 years ago.

Status:
In Progress
Priority:
Normal
Assignee:
Aurynn Shaw
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

We should be providing all date logging with timestamps, so that it's easier to work in our clients respective timezones

#1

Updated by Aurynn Shaw over 15 years ago

  • Status changed from New to In Progress

Okay. Ideas on changing the timezone based on the requesting user? Or should that even be necessary to do?

#2

Updated by Darcy Buskermolen over 15 years ago

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;

#3

Updated by Aurynn Shaw over 14 years ago

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

#4

Updated by bford - over 14 years ago

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

#5

Updated by Aurynn Shaw over 14 years ago

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

Also available in: Atom PDF