On 1/1/16 7:15 AM, Alban Hertroys wrote:
>> Since you're dealing with GPS data and presumably have lat/long, it shouldn't be hard to do this dynamically either,
eitherby just blindly dividing longitude by 15 or using actual timezone shape polygons and @> or <@.
> That would be a bad idea for global data, since not all time zones are full hours apart, or have the same (if any)
DSTchange-over dates. For example, India is currently at UTC+05:30, probably because they wrapped the entire country in
thesame TZ after their independence.
The original desire was to ignore DST, hence my suggestion. Normally
you'd want to figure out the correct TZ for the lat/long.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com