Re: [fw-db] User timezones

How are you setting the timezone ?

On Sun, Aug 9, 2009 at 12:21 PM, Sudheer Satyanarayana <sudheer.s@binaryvibes.co.in> wrote:

Gabriel Baez wrote:

Does anyone know the proper way for dealing with users that have a different timezone? I'm letting users select how they would like the time to be displayed, the selected timezone is stored in a table.

I have though of setting the timezone at the database level with "SET TIME ZONE <timezonehere> " but I'm not sure if that's the correct direction to go. Any ideas?

I set the timezone based on the user's timezone stored in the database. If the user's timezone is not stored in the database, I set a default timezone.


--

Sudheer Satyanarayana
Binary Vibes Information Technologies Pvt. Ltd.
Postal Address: #506, 10th B Main Road, I Block, Jayanagar, Bangalore – 560 011
URL : www.binaryvibes.co.in Phone: +91 80 41558451 * Mobile: +91 99005 07499 Community : http://techchorus.net