Menu
Here's a forecast for London, GB from the Open Weather Map in JSON format.
http://api.openweathermap.org/data/2.5/forecast/daily?id=524901
Each list item in the JSON has a key within it called dt that looks like "dt":1399626000
I haven't done this before, so how do I figure out what format (unix timestamp?) and timezone dt is in (e.g. GMT, UTC), and how to translate the dt into a human-friendly format.
245
By default, the date format is MM/DD/YYYY HH24:MI:SS.US. uses the default date format when you perform the following actions: Convert a date to a string by connecting a date/time port to a string port. converts the date to a string in the date format defined in the session configuration object.
The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations. To view a date serial number as a date, you must apply a date format to the cell.
The DATEVALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date. So, the formula to convert a text value to date is as simple as =DATEVALUE(A1) , where A1 is a cell with a date stored as a text string.
If I'm on the right page, the API documentation says here that it's a GMT Unix timestamp:
dt | Time of data receiving in unixtime GMT
To convert it into a human-readable format using JavaScript, see the answer to this question.
80
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
