summaryrefslogtreecommitdiff
path: root/jstests/core/monotonic_date_operations.js
diff options
context:
space:
mode:
Diffstat (limited to 'jstests/core/monotonic_date_operations.js')
-rw-r--r--jstests/core/monotonic_date_operations.js408
1 files changed, 408 insertions, 0 deletions
diff --git a/jstests/core/monotonic_date_operations.js b/jstests/core/monotonic_date_operations.js
new file mode 100644
index 00000000000..5e28967bc44
--- /dev/null
+++ b/jstests/core/monotonic_date_operations.js
@@ -0,0 +1,408 @@
+/**
+ * Tests that date expressions remain monotonic despite timezone changes.
+ */
+
+(function() {
+"use strict";
+
+const coll = db.monotonic_date_operations;
+
+const runTest = function(documents, pipeline, expectedDocs) {
+ coll.drop();
+ assert.commandWorked(coll.insertMany(documents));
+ pipeline.push({$sort: {_id: 1}});
+ assert.eq(coll.aggregate(pipeline).toArray(), expectedDocs);
+};
+
+const dateFormat = "%Y-%m-%dT%H:%M:%S.%L%z";
+
+// New York DST fall switch
+runTest(
+ [
+ {_id: 0, time: ISODate("2022-11-06T03:00:00Z")}, // 2022-11-05T23:00:00 in New York
+ {_id: 1, time: ISODate("2022-11-06T05:00:00Z")},
+ {_id: 2, time: ISODate("2022-11-06T05:30:00Z")},
+ {_id: 3, time: ISODate("2022-11-06T06:00:00Z")}, // Moment of DST switch
+ {_id: 4, time: ISODate("2022-11-06T06:30:00Z")},
+ {_id: 5, time: ISODate("2022-11-06T07:00:00Z")},
+ ],
+ [{
+ $project: {
+ localTime: {
+ $dateToString: {
+ date: "$time",
+ format: dateFormat,
+ timezone: "America/New_York",
+ }
+ },
+ diffMinutes: {
+ $dateDiff: {
+ startDate: ISODate("2022-11-06T04:00:00Z"),
+ endDate: "$time",
+ unit: "minute",
+ timezone: "America/New_York",
+ }
+ },
+ diffDays: {
+ $dateDiff: {
+ startDate: ISODate("2022-11-06T04:00:00Z"),
+ endDate: "$time",
+ unit: "day",
+ timezone: "America/New_York",
+ }
+ }
+ }
+ }],
+ [
+ {
+ _id: 0,
+ localTime: "2022-11-05T23:00:00.000-0400",
+ diffMinutes: NumberLong(-60),
+ diffDays: NumberLong(-1)
+ },
+ {
+ _id: 1,
+ localTime: "2022-11-06T01:00:00.000-0400",
+ diffMinutes: NumberLong(60),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 2,
+ localTime: "2022-11-06T01:30:00.000-0400",
+ diffMinutes: NumberLong(90),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 3,
+ localTime: "2022-11-06T01:00:00.000-0500",
+ diffMinutes: NumberLong(120),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 4,
+ localTime: "2022-11-06T01:30:00.000-0500",
+ diffMinutes: NumberLong(150),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 5,
+ localTime: "2022-11-06T02:00:00.000-0500",
+ diffMinutes: NumberLong(180),
+ diffDays: NumberLong(0)
+ }
+ ]);
+
+// New York DST spring switch
+runTest(
+ [
+ {_id: 0, time: ISODate("2022-03-13T06:00:00Z")}, // 2022-03-13T01:00:00 in New York
+ {_id: 1, time: ISODate("2022-03-13T06:30:00Z")},
+ {_id: 2, time: ISODate("2022-03-13T07:00:00Z")}, // Moment of DST switch
+ {_id: 3, time: ISODate("2022-03-13T07:30:00Z")},
+ {_id: 4, time: ISODate("2022-03-13T08:00:00Z")},
+ ],
+ [{
+ $project: {
+ localTime: {
+ $dateToString: {
+ date: "$time",
+ format: dateFormat,
+ timezone: "America/New_York",
+ }
+ },
+ diffMinutes: {
+ $dateDiff: {
+ startDate: ISODate("2022-03-13T00:00:00Z"),
+ endDate: "$time",
+ unit: "minute",
+ timezone: "America/New_York",
+ }
+ },
+ diffDays: {
+ $dateDiff: {
+ startDate: ISODate("2022-03-13T00:00:00Z"),
+ endDate: "$time",
+ unit: "day",
+ timezone: "America/New_York",
+ }
+ }
+ }
+ }],
+ [
+ {
+ _id: 0,
+ localTime: "2022-03-13T01:00:00.000-0500",
+ diffMinutes: NumberLong(360),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 1,
+ localTime: "2022-03-13T01:30:00.000-0500",
+ diffMinutes: NumberLong(390),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 2,
+ localTime: "2022-03-13T03:00:00.000-0400",
+ diffMinutes: NumberLong(420),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 3,
+ localTime: "2022-03-13T03:30:00.000-0400",
+ diffMinutes: NumberLong(450),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 4,
+ localTime: "2022-03-13T04:00:00.000-0400",
+ diffMinutes: NumberLong(480),
+ diffDays: NumberLong(1)
+ },
+ ]);
+
+// Samoa day skip
+runTest(
+ [
+ {_id: 0, time: ISODate("2011-12-29T10:00:00Z")},
+ {_id: 1, time: ISODate("2011-12-30T09:00:00Z")}, // 2011-12-29T23:00:00 in Apia, Samoa
+ {_id: 2, time: ISODate("2011-12-30T09:30:00Z")},
+ {_id: 3, time: ISODate("2011-12-30T10:00:00Z")}, // Day skip moment
+ {_id: 4, time: ISODate("2011-12-30T10:30:00Z")},
+ {_id: 5, time: ISODate("2011-12-30T11:00:00Z")},
+ {_id: 6, time: ISODate("2011-12-30T10:00:00Z")},
+ ],
+ [{
+ $project: {
+ localTime: {
+ $dateToString: {
+ date: "$time",
+ format: dateFormat,
+ timezone: "Pacific/Apia",
+ }
+ },
+ diffMinutes: {
+ $dateDiff: {
+ startDate: ISODate("2011-12-28T10:00:00Z"),
+ endDate: "$time",
+ unit: "minute",
+ timezone: "Pacific/Apia",
+ }
+ },
+ diffDays: {
+ $dateDiff: {
+ startDate: ISODate("2011-12-28T10:00:00Z"),
+ endDate: "$time",
+ unit: "day",
+ timezone: "Pacific/Apia",
+ }
+ }
+ }
+ }],
+ [
+ {
+ _id: 0,
+ localTime: "2011-12-29T00:00:00.000-1000",
+ diffMinutes: NumberLong(1440),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 1,
+ localTime: "2011-12-29T23:00:00.000-1000",
+ diffMinutes: NumberLong(2820),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 2,
+ localTime: "2011-12-29T23:30:00.000-1000",
+ diffMinutes: NumberLong(2850),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 3,
+ localTime: "2011-12-31T00:00:00.000+1400",
+ diffMinutes: NumberLong(2880),
+ diffDays: NumberLong(3)
+ },
+ {
+ _id: 4,
+ localTime: "2011-12-31T00:30:00.000+1400",
+ diffMinutes: NumberLong(2910),
+ diffDays: NumberLong(3)
+ },
+ {
+ _id: 5,
+ localTime: "2011-12-31T01:00:00.000+1400",
+ diffMinutes: NumberLong(2940),
+ diffDays: NumberLong(3)
+ },
+ {
+ _id: 6,
+ localTime: "2011-12-31T00:00:00.000+1400",
+ diffMinutes: NumberLong(2880),
+ diffDays: NumberLong(3)
+ },
+ ]);
+
+// Sao Paulo, Brazil DST fall switch
+runTest(
+ [
+ {
+ _id: 0,
+ time: ISODate("2018-11-04T02:00:00Z")
+ }, // 2018-11-03T23:00:00 in Sao Paulo, Brazil
+ {_id: 1, time: ISODate("2018-11-04T02:30:00Z")},
+ {_id: 2, time: ISODate("2018-11-04T03:00:00Z")}, // Moment of DST switch
+ {_id: 3, time: ISODate("2018-11-04T03:30:00Z")},
+ {_id: 4, time: ISODate("2018-11-04T04:00:00Z")},
+ {_id: 5, time: ISODate("2018-11-04T04:30:00Z")},
+ ],
+ [{
+ $project: {
+ localTime: {
+ $dateToString: {
+ date: "$time",
+ format: dateFormat,
+ timezone: "America/Sao_Paulo",
+ }
+ },
+ diffMinutes: {
+ $dateDiff: {
+ startDate: ISODate("2018-11-04T02:00:00Z"),
+ endDate: "$time",
+ unit: "minute",
+ timezone: "America/Sao_Paulo",
+ }
+ },
+ diffDays: {
+ $dateDiff: {
+ startDate: ISODate("2018-11-04T02:00:00Z"),
+ endDate: "$time",
+ unit: "day",
+ timezone: "America/Sao_Paulo",
+ }
+ }
+ }
+ }],
+ [
+ {
+ _id: 0,
+ localTime: "2018-11-03T23:00:00.000-0300",
+ diffMinutes: NumberLong(0),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 1,
+ localTime: "2018-11-03T23:30:00.000-0300",
+ diffMinutes: NumberLong(30),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 2,
+ localTime: "2018-11-04T01:00:00.000-0200",
+ diffMinutes: NumberLong(60),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 3,
+ localTime: "2018-11-04T01:30:00.000-0200",
+ diffMinutes: NumberLong(90),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 4,
+ localTime: "2018-11-04T02:00:00.000-0200",
+ diffMinutes: NumberLong(120),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 5,
+ localTime: "2018-11-04T02:30:00.000-0200",
+ diffMinutes: NumberLong(150),
+ diffDays: NumberLong(1)
+ },
+ ]);
+
+// Sao Paulo, Brazil DST sprint switch
+runTest(
+ [
+ {_id: 0, time: ISODate("2018-02-18T00:30:00Z")}, // 2018-02-17T22:30:00 in Sao Paulo, Brazi
+ {_id: 1, time: ISODate("2018-02-18T01:00:00Z")},
+ {_id: 2, time: ISODate("2018-02-18T01:30:00Z")},
+ {_id: 3, time: ISODate("2018-02-18T02:00:00Z")}, // Moment of DST switch
+ {_id: 4, time: ISODate("2018-02-18T02:30:00Z")},
+ {_id: 5, time: ISODate("2018-02-18T03:00:00Z")},
+ {_id: 6, time: ISODate("2018-02-18T03:30:00Z")},
+ ],
+ [{
+ $project: {
+ localTime: {
+ $dateToString: {
+ date: "$time",
+ format: dateFormat,
+ timezone: "America/Sao_Paulo",
+ }
+ },
+ diffMinutes: {
+ $dateDiff: {
+ startDate: ISODate("2018-02-18T00:30:00Z"),
+ endDate: "$time",
+ unit: "minute",
+ timezone: "America/Sao_Paulo",
+ }
+ },
+ diffDays: {
+ $dateDiff: {
+ startDate: ISODate("2018-02-18T00:30:00Z"),
+ endDate: "$time",
+ unit: "day",
+ timezone: "America/Sao_Paulo",
+ }
+ }
+ }
+ }],
+ [
+ {
+ _id: 0,
+ localTime: "2018-02-17T22:30:00.000-0200",
+ diffMinutes: NumberLong(0),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 1,
+ localTime: "2018-02-17T23:00:00.000-0200",
+ diffMinutes: NumberLong(30),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 2,
+ localTime: "2018-02-17T23:30:00.000-0200",
+ diffMinutes: NumberLong(60),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 3,
+ localTime: "2018-02-17T23:00:00.000-0300",
+ diffMinutes: NumberLong(90),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 4,
+ localTime: "2018-02-17T23:30:00.000-0300",
+ diffMinutes: NumberLong(120),
+ diffDays: NumberLong(0)
+ },
+ {
+ _id: 5,
+ localTime: "2018-02-18T00:00:00.000-0300",
+ diffMinutes: NumberLong(150),
+ diffDays: NumberLong(1)
+ },
+ {
+ _id: 6,
+ localTime: "2018-02-18T00:30:00.000-0300",
+ diffMinutes: NumberLong(180),
+ diffDays: NumberLong(1)
+ }
+ ]);
+})();
generated by cgit v1.2.3 (git 2.39.1) at 2026-09-11 09:53:52 +0000