Patch #1705

Use Rails timezones support

Added by Artem Vasiliev over 3 years ago. Updated 11 months ago.

Status:New Start date:2008-07-29
Priority:Normal Due date:
Assignee:- % Done:

0%
Category:Rails support
Target version:-

Description

This switches off previous time offset calculation when showing time values to user, relying on Rails timezones support instead.

This is essential for cases when time is entered by user, so we need this for our #1650 patch (otherwise user sees his time +his timezone offset).

This doesn't bring much to current Redmine as all the time fields are populated automatically currently. May be it could be used to correct SCM timestamps if some give it in non-UTC. And surely this will help time values in custom fields when they support it.

After this patch is applied all the datetimes in the database will be interpreted as being in UTC, so if they don't they need to be updated. For this new redmine:convert_database_times_to_utc rake task is included. Be sure to correct its LOCAL_UTC_OFFSET and back up the database prior to running.

Contributed by Texuna Technologies.

rails_timezones.patch (3.8 kB) Artem Vasiliev, 2008-07-29 15:09

rails_timezones.patch - typo fixed in rake task (3.8 kB) Artem Vasiliev, 2008-07-29 15:32

Related issues

related to Feature #2531: "Within period" query filters for date fields Closed 2009-01-19
related to Defect #3734: fetch_changesets save local time instead of GMT in the da... New 2009-08-13
related to Defect #5560: Changing System Time Zone Causes Issue Updates to Change ... New 2010-05-19

History

#1
Updated by Artem Vasiliev over 3 years ago

http://mad.ly/2008/04/09/rails-21-time-zone-support-an-overview/ has good introduction to (and discussion of) Rails 2.1 timezones support.

#2
Updated by Artem Vasiliev over 3 years ago

Also config/environment.rb need to be adjusted for particular server (config.time_zone setting)

#4
Updated by Artem Vasiliev about 3 years ago

This is used in #2531's implementation

#5
Updated by Toshi MARUYAMA 11 months ago

  • Category set to Rails support

Also available in: Atom PDF