578556 - REST BzAPI sometimes returns dates in the future (possibly only for history items)

Status: RESOLVED FIXED

(Webtools Graveyard :: BzAPI, defect)

Description

[LegNeato]

Compare:

    https://bugzilla.mozilla.org/show_activity.cgi?id=415086

and 

    https://api-dev.bugzilla.mozilla.org/latest/bug/415086/history

The first one has mnot added to the cc at:

    2010-07-13 17:36:36 PDT

and the second one has mnot added to the cc at:

    change_time: 2010-07-14T07:36:36Z

(which is in the future btw).

Comment 1

[Gervase Markham [:gerv]]

Ah, this would be me not correctly taking into account the fact that the XML-RPC API, on which history is based, now returns all times in UTC. I will look into this. In the mean time, you may have to work out what's going on (there will be a constant offset of some sort, I suspect) and adjust accordingly temporarily.

Gerv

Comment 2

[LegNeato]

Looks like I need to subtract 14:00:00 from the datetime to get the proper times

Comment 3

[LegNeato]

Hmmm, that doesn't work for all cases (2010-07-15T21:20:05Z
 vs 2010-07-16T04:20:05Z for bug 578779, the difference is 7 hours)

Comment 4

[LegNeato]

Ok, this is weird but I think I know what is going on. It looks like the "last_change_time" field is +7 hours while the timestamps for the changes are +14 hours.

Comment 5

[Gervase Markham [:gerv]]

OK, the test suite now passes against Bugzilla 3.6, having fixed some timezone-related issues. So all times should now be correct. Look for this change in the next BzAPI release.

Gerv