[Developers] datetime format

[Christopher R. Maden]

Arthur van Hoff wrote:
> Not sure I understand, both styles occur in my property values, and
> the documentation does not mention the first format. I guess I need
> to read both? I assume that the -00:00 is a timezone. Why is that
> included if we always use UTC?

Sorry, Arthur; I didn’t have enough coffee to read your first message 
correctly.

Datetimes set via the UI are always stored in 2008-01-28T07:24:17.000Z 
format.  However, most valid ISO 8601 expressions will be accepted (and 
stored) by the middle tier; it looks like the population of datetimes in 
podcast publication date values was done by an automated script using 
the 2008-01-28T07:24:17-00:00 format.

If these values are compared or manipulated in an ISO 8601-aware 
context, including (I believe, though I will check) in MQL, they should 
compare identically.

~Chris
-- 
Christopher R. Maden
Data Architect
Metaweb Technologies, Inc.
<URL: http://www.metaweb.com/ >