Different timezones for multiple databases...

[V1c70r]

I have a rails app with two database connections. My own database contains datetime fields in UTC. An external database contains datetime fields in EET/EEST. How can I set different timezones for two database connections? I think this is impossible...

[rafaelfranca]

Please use the mailing list or StackOverflow for questions/help, where a wider community will be able to help you. We reserve the issues tracker for issues only.

[V1c70r]

But you can't set different default timezone for multiple databases. I think this is an issue...

[rafaelfranca]

I don't consider. I see this more as a feature request. And feature requests can't be made in the issue tracker too.

[halida]

Facing the same problem, @V1c70r Do you have made an workaround?

ActiveRecord use value.in_time_zone in attribute_methods/time_zone_conversion.rb to convert timezone, which cannot be configured.
If we add a parameter for ActiveRecord, we can set ActiveRecord timezone separately, but it is still global, and cannot config timezone by connection.

[V1c70r]

@halida I monkey patched ActiveRecord for a workaround. Sorry but I lost sources.