Page 1 of 1

Timezones in sybase databases

Posted: Fri Oct 29, 2004 5:42 am
by Tubbietoeter
Hi,


I have a sybase-based database here (Micromuse Netcool Object Server) and I want to convert the dates that are stored in this DB on UTC into a different timezone the user can chose before displaying the output on the web.
However, until now I have not found a way to achieve this.

Does someone have an idea?

Thanks,

Steff

Posted: Fri Oct 29, 2004 7:04 am
by kettle_drum
As long as all the times in the database are recorded in the same timezone you can simply ask the user for their own time zone and then add or subtract 60*60*difference_in_user_time_zone_from_servers.

Posted: Fri Oct 29, 2004 7:44 am
by Tubbietoeter
Thanks, I guess this will do. :)