Date Format - Githubissues

openeventdatabase / backend

code behind api.openeventdatabase.org

GNU Affero General Public License v3.0

43 stars 7 forks source link

Date Format #20

Closed dtissera closed 7 years ago

dtissera commented 7 years ago

I call api with url below http://api.openeventdatabase.org/event?what=alert.emergency&near=2.36,48.85,30000.0&when=lastmonth

Date fields do not have the same format exemple:

createdate: "2016-10-27T12:00:13.356219"
lastupdate: "2016-10-27T12:00:13.356219"
start: "2016-10-27T13:59:00+02:00"
stop: "2016-11-26T13:59:00+01:00"

The wiki talk about timestamp !

1) Is it possible to use the same format for all date fields ? 2) with UTC ?

Thanks

Morendil commented 7 years ago

Are you having trouble parsing the dates?

The date formats are https://fr.wikipedia.org/wiki/ISO_8601 - libraries that can parse ISO8601 should be able to deal with its variants, although I'd agree it's not ideal that the format differs across fields.

cquest commented 7 years ago

All these dates are valid ISO8601 dates.

When the timezone is not given, it is UTC.

Start/stop/when properties values are the one provided during the POST/PUT. Removing timezone info also mean remove some metadata about these timestamps.

createdate/lastupdate are generated by the API up to microsecond to track changes that can happen more than once during a single second and they are always at UTC (the API backend runs on UTC clock). I could add "UTC" for them to make it explicit.