Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Unicode.org hosts a mapping as part of the CLDR. <a href="http://www.unicode.org/cldr/charts/latest/supplemental/zone_tzid.html" rel="noreferrer">You can get to the latest version here</a>. There are also XML versions of the data linked from that page.</p> <p>You can find example code (in Python) of how to generate a mapping from the XML data <a href="http://svn.plone.org/svn/collective/p4a/Plone4ArtistsCalendar/tztest/trunk/tztest/get_windows_info.py" rel="noreferrer">here</a>.</p> <p><em>Obligatory Time Zone Rant:</em></p> <p>Note that whoever implemented the timezone support in Windows was on drugs. I'm not kidding you. Look at the timezone names. Why is Central European time known as "Romance standard Time". Romance? What, because it includes Paris, or? Roman Standard Time could have made sense a it also includes Rome, but Romance!?</p> <p>Also, in the registry the timezones are not organized under their id. No, they are, insanely, organized under their <em>display name</em>! Since that is localized, it means every timezone will be located under a different key in different translations of Windows!!! So to find the right timezone, you have to look through all the timezone to see which has the correct id.</p> <p>I have example code of that too <a href="http://svn.plone.org/svn/collective/p4a/Plone4ArtistsCalendar/tztest/trunk/tztest/__init__.py" rel="noreferrer">here</a>. See the <code>get_win_timezone()</code> function.</p> <p>I wonder if it is the same guy who designed this that decided that POSIX should reverse the sign on timezones, so that -8 hours mean <em>plus</em> 8 hours. In any case, I'm sure they were smoking something illegal together.</p>
    singulars
    1. This table or related slice is empty.
    1. POLinux- Windows Timezone Mapping?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMatt Johnson
    1. USLennart Regebro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLinux- Windows Timezone Mapping?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks Lennart and NullToken :)
      singulars
      1. PO
      1. USSathish Guru
    2. COBeware that as of Jan 25, 2013 the timezone data at unicode.org is at least 7 years outdated. So far, I have found that it is missing Asia/Kolkata (renamed from Asia/Calcutta), America/Indiana/Indianapolis, and America/Kentucky/Louisville. This is still ok for mapping Windows timezones to Linux, but I wouldn't use this data for anything more until it's fixed.
      singulars
      1. PO
      1. USgeofflee
    3. CO@geofflee: That's unfortunate, I didn't know they even had timezone data, and I don't see why they do if they don't keep it updated. Anyway, I use it only for the timezone name mapping.
      singulars
      1. PO
      1. USLennart Regebro
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload