We had to create a reporting software that connects to multiple
databases that are all in different time zones. Is there any way for
us to tell Rails which time zone each database is in and still be able
to have time zone support?
I need to be able to tell rails to pull the data from the various
database servers (easy enough) and display them in the user’s timezone
(can’t do it). Problem is, Rails either thinks the data is in UTC or
Local (rails app server) time zone.
I can’t seem to find how to make it work. To tell Rails to get the
data from a time zone of Mountain Time (US & Canada) and do the
conversion from there instead of UTC.
Example -
Reporting Application Server:
Rails 2.3.2
Local Server TZ => Central Time (US)
Data Storage: Main Database Server, UTC TZ
Application #1:
Rails 2.3.2
Local Server TZ => Central Time (US)
Data Storage: Main DB Server, UTC TZ
Application #2:
PHP
Local Server TZ => Central Time (US)
Data Storage: Main DB Server, Central TZ
Application #3:
PHP
Local Server TZ => Eastern Time (US)
Data Storage: Secondary DB Server, Eastern TZ
Main Database Server:
Local Server TZ => Central Time (US)
Secondary DB:
Local Server TZ => Eastern Time (US)