|
|
Posted by Daniel Tryba on 06/24/05 16:09
Google Mike <googlemike@hotpop.com> wrote:
> What I want to do is have a web app that one logs into (great place for
> submitting the browser's view on time via Javascript) and then the user
> sees the records from the database with dates converted from GMT to
> their local timezone. The database, however, will only store GMT time
> for all the records. (Imagine a simplistic, one-table helpdesk
> ticketing system for the style of database to make this easy. Oh, and
> I'm more a fan of PostgreSQL than MySQL.)
Take the KISS approach: leave _everything_ in GMT. That way you only
have to tell the user his offset to GMT or even more simply just tell
him the time in GMT when the page was loaded.
Navigation:
[Reply to this message]
|