diff options
author | David Lawrence <dkl@mozilla.com> | 2016-05-14 16:09:38 +0200 |
---|---|---|
committer | David Lawrence <dkl@mozilla.com> | 2016-05-14 16:09:38 +0200 |
commit | 35df2cd5bc44b1f369ca6d32dfe1c600c1608dc4 (patch) | |
tree | 7817fa1c5616ce13268e7aecd6dde23f24ba314c /extensions/BMO/lib/Reports/ReleaseTracking.pm | |
parent | 627be9de2e720f289f0b151c0057be7af0e84a72 (diff) | |
download | bugzilla-35df2cd5bc44b1f369ca6d32dfe1c600c1608dc4.tar.gz bugzilla-35df2cd5bc44b1f369ca6d32dfe1c600c1608dc4.tar.xz |
Bug 232193 - bmo's systems (webheads, database, etc) should use UTC natively for o/s timezone and date storage
Diffstat (limited to 'extensions/BMO/lib/Reports/ReleaseTracking.pm')
-rw-r--r-- | extensions/BMO/lib/Reports/ReleaseTracking.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/extensions/BMO/lib/Reports/ReleaseTracking.pm b/extensions/BMO/lib/Reports/ReleaseTracking.pm index 0d9a51583..8894a5169 100644 --- a/extensions/BMO/lib/Reports/ReleaseTracking.pm +++ b/extensions/BMO/lib/Reports/ReleaseTracking.pm @@ -367,9 +367,9 @@ sub report { push @where, "(a.fieldid = ?)"; push @params, $q->{field_id}; - push @where, "(a.bug_when >= ?)"; + push @where, "(CONVERT_TZ(a.bug_when, 'UTC', 'America/Los_Angeles') >= ?)"; push @params, $q->{start_date} . ' 00:00:00'; - push @where, "(a.bug_when <= ?)"; + push @where, "(CONVERT_TZ(a.bug_when, 'UTC', 'America/Los_Angeles') <= ?)"; push @params, $q->{end_date} . ' 23:59:59'; push @where, "(a.added LIKE ?)"; |