Project

General

Profile

Feature #13803 » 0001-Implemented-for-MySQL-as-well_v2.patch

Marius BĂLTEANU, 2018-12-15 16:29

View differences:

lib/redmine/database.rb
74 74
          else
75 75
            "#{column}::date"
76 76
          end
77
        elsif mysql?
78
          if time_zone
79
            user_identifier = ActiveSupport::TimeZone.find_tzinfo(time_zone.name).identifier
80
            local_identifier = ActiveSupport::TimeZone.find_tzinfo(Time.zone.name).identifier
81
            "CONVERT_TZ(DATE(#{column}),'#{local_identifier}', '#{user_identifier}')"
82
          else
83
            "DATE(#{column})"
84
          end
77 85
        end
78 86
      end
79 87

  
(3-3/3)