Measures fail (probably timezone related)

[MathieuNls]

The user claims to be on Pacific timezone (UTC -9) and most of his measure are at UTC-9, so this information holds.

However, when the user make a measure after 3 p.m pacific time (00:00 am the next day UTC time), the day is not incremented on the MRT and ART fields (MeasureReferenceTime and AccuracyReferenceTime) which represent the server time for measure 1/2 and 2/2, respectively.

See measures with diffs around -15 hours in the following extract.

id,brand,name,"MUT (1/2 user)","MRT (1/2 server)","diff (hours) 1/2","AUT (2/2 user)","ART (2/2 server)","diff (hours) 2/2","diff substraction",prec
85100,bremont,supermarine,"2015-12-26 13:39:56","2015-12-26 22:39:53",8.9992,"2015-12-27 06:50:02","2015-12-27 15:49:57",8.9986,0.0006,2.7959
85157,bremont,supermarine,"2015-12-28 07:36:39","2015-12-28 16:36:31",8.9978,"2015-12-29 07:33:14","2015-12-29 16:33:02",8.9967,0.0011,4.0097
85174,bremont,supermarine,"2015-12-29 07:39:53","2015-12-29 16:39:41",8.9967,"2016-01-01 10:40:57","2016-01-01 19:40:29",8.9922,0.0044,5.1191
85234,bremont,supermarine,"2016-01-01 10:43:54","2016-01-01 19:43:25",8.9919,"2016-01-03 10:34:21","2016-01-03 19:33:48",8.9908,0.0011,2.0067
85101,"bremont 2",supermarine,"2015-12-26 13:41:38","2015-12-26 22:41:36",8.9994,"2015-12-27 06:56:47","2015-12-27 15:56:42",8.9986,0.0008,4.1735
85102,"bremont 3",,"2015-12-26 13:42:22","2015-12-26 22:42:20",8.9994,"2015-12-27 06:57:33","2015-12-27 15:57:29",8.9989,0.0006,2.7822
-> 85105,"bremont 4",,"2015-12-27 15:12:37","2015-12-27 00:12:35",-15.0006,"2015-12-27 07:00:49","2015-12-27 16:00:44",8.9986,-23.9992,-131215.1875
85126,"bremont 4",,"2015-12-27 07:02:21","2015-12-27 16:02:16",8.9986,"2015-12-28 07:09:10","2015-12-28 04:09:04",-3.0017,12.0003,85593.6159
-> 85142,"bremont 4",,"2015-12-28 19:16:28","2015-12-28 04:16:21",-15.0019,"2015-12-28 07:28:46","2015-12-28 16:28:38",8.9978,-23.9997,-169899.4834
85151,"bremont 4",,"2015-12-28 07:31:10","2015-12-28 16:31:02",8.9978,"2015-12-29 07:34:53","2015-12-29 16:34:41",8.9967,0.0011,3.9899
-> 85106,"bremont 5",,"2015-12-27 15:14:26","2015-12-27 00:14:23",-15.0008,"2015-12-27 07:03:13","2015-12-27 16:03:08",8.9986,-23.9994,-131133.7233
85127,"bremont 5",,"2015-12-27 07:04:15","2015-12-27 16:04:10",8.9986,"2015-12-28 19:10:21","2015-12-28 04:10:14",-15.0019,24.0006,171360.1322
85153,"bremont 5",,"2015-12-28 07:34:16","2015-12-28 16:34:09",8.9981,"2015-12-29 07:35:37","2015-12-29 16:35:24",8.9964,0.0017,5.9948
-> 85108,"bremont 6",,"2015-12-27 17:02:37","2015-12-27 02:02:35",-15.0006,"2015-12-27 07:05:36","2015-12-27 16:05:32",8.9989,-23.9994,-147592.5262
85128,"bremont 6",,"2015-12-27 07:07:26","2015-12-27 16:07:22",8.9989,"2015-12-28 19:11:21","2015-12-28 04:11:15",-15.0017,24.0006,171876.9783
85154,"bremont 6",,"2015-12-28 07:35:12","2015-12-28 16:35:05",8.9981,"2015-12-29 07:36:09","2015-12-29 16:35:57",8.9967,0.0014,4.9970
-> 85109,"bremont 7",,"2015-12-27 17:03:51","2015-12-27 02:03:48",-15.0008,"2015-12-27 07:08:25","2015-12-27 16:08:20",8.9986,-23.9994,-147315.8194
85129,"bremont 7",,"2015-12-27 07:09:40","2015-12-27 16:09:34",8.9983,"2015-12-28 19:17:18","2015-12-28 04:17:11",-15.0019,24.0003,170993.1145
85155,"bremont 7",,"2015-12-28 07:35:36","2015-12-28 16:35:29",8.9981,"2015-12-29 07:36:36","2015-12-29 16:36:24",8.9967,0.0014,4.9968
85122,"bremont 8",,"2015-12-27 06:53:10","2015-12-27 15:53:05",8.9986,"2015-12-28 19:23:14","2015-12-28 04:23:07",-15.0019,24.0006,165884.4674
85158,"bremont 8",,"2015-12-28 07:37:05","2015-12-28 16:36:57",8.9978,"2015-12-29 07:37:16","2015-12-29 16:37:04",8.9967,0.0011,3.9997
85123,"bremont 9",,"2015-12-27 06:54:08","2015-12-27 15:54:04",8.9989,"2015-12-28 19:57:54","2015-12-28 04:57:47",-15.0019,24.0008,158756.7616
85160,"bremont 9",,"2015-12-28 07:37:36","2015-12-28 16:37:28",8.9978,"2015-12-29 07:37:43","2015-12-29 16:37:31",8.9967,0.0011,3.9999
85124,"bremont 10",,"2015-12-27 06:55:25","2015-12-27 15:55:20",8.9986,"2015-12-28 19:05:15","2015-12-28 04:05:09",-15.0017,24.0003,170477.6633
-> 85140,"bremont 10",,"2015-12-28 19:15:10","2015-12-28 04:15:03",-15.0019,"2015-12-28 07:27:25","2015-12-28 16:27:18",8.9981,-24.0000,-169909.1840
85150,"bremont 10",,"2015-12-28 07:30:15","2015-12-28 16:30:07",8.9978,"2015-12-29 07:33:43","2015-12-29 16:33:32",8.9969,0.0008,2.9929
85175,"bremont 10",,"2015-12-29 07:40:26","2015-12-29 16:40:13",8.9964,"2016-01-01 10:41:42","2016-01-01 19:41:14",8.9922,0.0042,4.7989
85233,"bremont 10",,"2016-01-01 10:43:01","2016-01-01 19:42:32",8.9919,"2016-01-03 10:37:16","2016-01-03 19:36:43",8.9908,0.0011,2.0040
85125,"bremont 11",,"2015-12-27 06:59:36","2015-12-27 15:59:32",8.9989,"2015-12-28 19:07:53","2015-12-28 04:07:46",-15.0019,24.0008,170852.2726
-> 85141,"bremont 11",,"2015-12-28 19:15:55","2015-12-28 04:15:49",-15.0017,"2015-12-28 07:28:07","2015-12-28 16:27:59",8.9978,-23.9994,-169924.5891
85152,"bremont 11",,"2015-12-28 07:33:20","2015-12-28 16:33:12",8.9978,"2015-12-29 07:34:25","2015-12-29 16:34:12",8.9964,0.0014,4.9965

[MathieuNls]

If I add 1 day server time at 1/2 for measure 85105

# id, brand, name, MUT (1/2 user), MRT (1/2 server), diff (hours) 1/2, AUT (2/2 user), ART (2/2 server), diff (hours) 2/2, diff substraction, prec
'85105', 'bremont 4', '', '2015-12-27 15:12:37', '2015-12-28 00:12:35', '8.9994', '2015-12-27 07:00:49', '2015-12-27 16:00:44', '8.9986', '0.0008', '-8.7832'

Then, the computation seams correct.

[AlphonseJr]

Si jamais t'as une dispo demain, je veux bien qu'on se capte pour un Skype en vitesse !

[MathieuNls]

#58