Historical Time Series - Time Date Formats

Historical Time Series - Time Date Formats

Solcast Products

Grid Aggregations
Typical Meteorological Year (TMY)
Geographic Horizon Angles


Modelling - FAQsModelling - FAQs

Solcast API

Third Party Applications

Hobbyists and Researchers

Troubleshooting and FAQs

FAQsFAQsTroubleshooting Data ErrorsTroubleshooting Data Errors

Useful Links

Postman API (Spec) Documentation

API Change LogAPI Change LogSubscription ManagementSubscription ManagementAccount FAQs

We dive into the Timezone Picker. UTC or Longitude or Fixed offset from UTC

Timezone calculation is tricky, and we want to clarify in the Solcast toolkit the calculations when you select UTC or Longitude or Fixed offset from UTC.

When exporting Historical Time Series data from the Solcast toolkit you are presented with the following:


So what does this mean?


When selecting UTC, the period_end column in the export will be in UTC. For example, for the 1st of January 2007, at 1am it will be: 2007-01-01T01:00:00Z


When selecting Longitudinal the system will adjust the time within the period_end column based off the longitudinal co-ordinate with the standard timezones of the world. An example of these timezones are presented below:


1.1: Diagram of Standard Timezones of the World

Therefore using the same example as above and exported for Sydney (standard offset of +10:00), the date time exported in this column would be 2007-01-01T11:00:00+10:00

Now you may have noticed above that there is a suffix of +10:00. This is only an indicator of how much offset has been applied to the date and time.

Fixed offset from UTC

Similar to selecting the longitudinal time, however this allows you the capability to select any offset you desire. However using the same example as above, if we selected +10 for the offset, the output date time format in the period_end column would be 2007-01-01T11:00:00+10:00


To sum up all the different formats in the above example, included below is a table sample, with the longitudinal co-ordinate of Sydney, along with an offset of +10 for the fixed offset.

Fixed Offset from UTC

This row of the export should all produce the same value, as it’s referencing the same time

Note: The suffix offset, is an indicator only to allow you to know how much the date time has been adjusted by in comparison with UTC

Diagram 1.1:

UnaitxuGV, Heitordp and others, Public domain, via Wikimedia Commons.

Public Domain, https://commons.wikimedia.org/w/index.php?curid=22556731