search

3rww / rainfall

Search, visualize, and download real-time and historic hyper-local rainfall data in Allegheny County, PA
https://3rww.github.io/rainfall/
Apache License 2.0
4 stars 2 forks source link

Timestamp formatting in results #18

Open gassc opened 3 years ago

gassc commented 3 years ago

The ISO formatting isn't Excel-friendly. Return results with something that is human readable and a standard.

gassc commented 2 weeks ago

Currently, timestamps (including timezone offset) are returned using the RFC 3339 standard (ISO-8061 format). Excel doesn't automatically parse this out, requiring an extra step for end-users of the CSV download. We can return a spec that Excel will automatically parse.

Not sure what downstream is expecting ISO-8061 formattted datetimes. Need to investigate first.