CODEWITHSUNDEEP
phpwindowstimezone
Jason
Jason

Reputation: 4772

Windows time locales to PHP locales

I am developing a PHP application that is provided with timestamps from a Dynamics CRM. Each timestamp is provided in ISO8601 format, so we get the the time relative to UST.

Now, we also get a timezone number. This is needed so we can display the timezone properly. For example, we may be given 16:00+1 in the Summer with a timezone of 85 (UK, I bvelieve), so that would be displayed as 16:00 BST.

PHP when displaying a formatted date and time using the DateTime class, needs timezones in this kind of format: "Europe/London".

Now, what I need, is a translation from the Dynamic's "85" to PHP's "Europe/London". I don't know what either of those two lists are called (85 looks like something I remember from DOS days), and I cannot find any mapping tables or lists anywhere.

In short: we have - or can derive - essentially unix timestamps on PHP, and are given a "timezone" number from MS Dynamics, and need to be able to display that timestamp in a format appropriate to the timezone, e.g. "16:00 BST", "15:00 GMT", "11:00 EST".

Upvotes: 0

Views: 147

Answers (1)

Florian Brinker
Florian Brinker

Reputation: 735

Here is a table that explains the meaning of your code 85: http://msdn.microsoft.com/en-us/library/aa226764(v=sql.80).aspx

But you cannot define the location (Eu/London) in the timezone exactly.

Upvotes: 1

Related Questions