SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2003
    Location
    Melbourne, Australia
    Posts
    463
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    table of world times (zones+daylight savings)

    hi all

    not really an sql question
    but does anyone know where i can get a hold of a table or something
    that has all the main timezones, whether they have daylight savings or not, descriptions (locales)

    in sql format or something like that
    don't really want to enter it myself

    thanks
    dave

  2. #2
    Non-Member DaveMichaels's Avatar
    Join Date
    Nov 2004
    Location
    US
    Posts
    535
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    SitePoint Evangelist
    Join Date
    Mar 2003
    Location
    Melbourne, Australia
    Posts
    463
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks
    i guess i'll have to assume that there isn't a list in sql format then

  4. #4
    Non-Member QiSoftware's Avatar
    Join Date
    Oct 2004
    Location
    U.S.
    Posts
    366
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP Code:
    (GMT -12:00EniwetokKwajalein
    (GMT -11:00Midway IslandSamoa
    (GMT -10:00Hawaii
    (GMT -9:00Alaska
    (GMT -8:00Pacific Time (US &ampCanada)
    (
    GMT -7:00Mountain Time (US Canada)
    (
    GMT -6:00Central Time (US Canada), Mexico City
    (GMT -5:00Eastern Time (US Canada), BogotaLima
    (GMT -4:00Atlantic Time (Canada), CaracasLa Paz
    (GMT -3:30Newfoundland
    (GMT -3:00BrazilBuenos AiresGeorgetown
    (GMT -2:00Mid-Atlantic
    (GMT -1:00 hourAzoresCape Verde Islands
    (GMTWestern Europe TimeLondonLisbonCasablanca
    (GMT +1:00 hourBrusselsCopenhagenMadridParis
    (GMT +2:00KaliningradSouth Africa
    (GMT +3:00BaghdadRiyadhMoscowStPetersburg
    (GMT +3:30Tehran
    (GMT +4:00Abu DhabiMuscatBakuTbilisi
    (GMT +4:30Kabul
    (GMT +5:00EkaterinburgIslamabadKarachiTashkent
    (GMT +5:30BombayCalcuttaMadras, New Delhi
    (GMT +6:00AlmatyDhakaColombo
    GMT 
    6.5 Hours
    (GMT +7:00BangkokHanoiJakarta
    (GMT +8:00BeijingPerthSingaporeHong Kong
    (GMT +9:00TokyoSeoulOsakaSapporoYakutsk
    (GMT +9:30AdelaideDarwin
    (GMT +10:00Eastern AustraliaGuamVladivostok
    (GMT +11:00MagadanSolomon Islands, New Caledonia
    (GMT +12:00AucklandWellingtonFijiKamchatka
    GMT 
    13 Hours 

  5. #5
    SitePoint Member
    Join Date
    Dec 2004
    Location
    Germany
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have the same problem. The list above, is this something like a standard, or only c&p from "a famous board"?

    What I have found is http://www.twinsun.com/tz/tz-link.htm

    But this database ftp://elsie.nci.nih.gov/pub/tzdata2005e.tar.gz contains much more information, and it is only available in english language (as I can see).


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •