[SERVER-55224] Fix $dateDiff for timezones with non-whole hour Daylight Savings Time UTC offset changes for minute and second units Created: 16/Mar/21  Updated: 29/Oct/23  Resolved: 10/Jun/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Mindaugas Malinauskas Assignee: Mindaugas Malinauskas
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Related
is related to SERVER-55267 Fix $dateAdd Daylight Savings time co... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v5.0
Sprint: Query Execution 2021-03-22, Query Execution 2021-04-05, Query Execution 2021-04-19, Query Execution 2021-05-03, Query Execution 2021-05-31, Query Execution 2021-06-14
Participants:

 Description   

$dateDiff does not work correctly for Australia/Lord_Howe timezone for time units of minute/second. The problem is that Australia/Lord_Howe timezone turns the clock forward/back by 30 minutes (instead of 1 hour) when transitioning to/from Daylight Savings time. 



 Comments   
Comment by Vivian Ge (Inactive) [ 06/Oct/21 ]

Updating the fixversion since branching activities occurred yesterday. This ticket will be in rc0 when it’s been triggered. For more active release information, please keep an eye on #server-release. Thank you!

Comment by Githook User [ 10/Jun/21 ]

Author:

{'name': 'Mindaugas Malinauskas', 'email': 'mindaugas.malinauskas@mongodb.com'}

Message: SERVER-55224 Fix $dateDiff for timezones with non-whole hour Daylight Savings Time UTC offset changes for minute and second units
Branch: master
https://github.com/mongodb/mongo/commit/2267d1dfd1ed6e0cdde57461c157f36ee3a6edb5

Generated at Thu Feb 08 05:35:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.