Timezones

Wikidata Query

• https://qlever.cs.uni-freiburg.de/wikidata/C9sMHu

# truly tabular naive query for 
# Q12143:time zone
# generated by trulytabular.py version 0.4.11 on 2023-12-04T08:20:24.181324
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?time_zoneItem ?time_zone
  ?UTC_timezone_offset
  ?IANA_timezone_ID
  ?short_name
WHERE {
  # instanceof Q12143:time zone
  ?time_zoneItem wdt:P31/wdt:P279* wd:Q12143.
  # label
  ?time_zoneItem rdfs:label ?time_zone. 
  FILTER (LANG(?time_zone) = "en").
  # UTC timezone offset (P2907)
  OPTIONAL { 
    ?time_zoneItem wdt:P2907 ?UTC_timezone_offset. 
  }
  # IANA timezone ID (P6687)
  OPTIONAL { 
    ?time_zoneItem wdt:P6687 ?IANA_timezone_ID. 
  }
  OPTIONAL {
    ?time_zoneItem wdt:P1813 ?short_name .
	FILTER (LANG(?short_name) = "en").
  }
} ORDER BY ?short_name

Links

• https://www.ibm.com/docs/en/cloudpakw3700/2.3.0.0?topic=SS6PD2_2.3.0/doc/psapsys_restapi/time_zone_list.htm
• https://en.wikipedia.org/wiki/Coordinated_Universal_Time