Randomest way to sort time zones?
-
A small sample of the time zone selection list when signing up for an account at Jobvite.com:
-
@sparr I am curious as to just what the ORDER BY criteria look like.
On second thought, I really don't want to know.
-
@scholrlea Easy - no ORDER BY criteria.
-
@scholrlea
My guess is the sort clause looks like this:
-
@sparr said in Randomest way to sort time zones?:
What time zone is GMTZ? If that refers to GMT (plus Z for Zone, I suppose) then it’s clearly wrong for Ethiopia, which is at EAT, or UTC+3.
-
@gurth said in Randomest way to sort time zones?:
What time zone is GMTZ? If that refers to GMT (plus Z for Zone, I suppose) then it’s clearly wrong for Ethiopia, which is at EAT, or UTC+3.
Z is for Zulu time, not Zone, so "GMTZ" is redundant. Ethiopia is in Charlie time, so I don't know where that mapping is coming from.