CODEWITHSUNDEEP
java.nettimezonegeocoding
antonsyd
antonsyd

Reputation: 5

Compute difference btw. times at different locations/timezones (accounting for daylight savings)

I need to be able to compute differences between two data/time values which represent instants in (potentially) two different geographic locations.

Each input value I have is a tuple of the following:

From any combination of two input values, I need to compute the time difference (which may be minutes, days, years, etc.). To start with, I need to:

Can anyone please suggest how I can:

  1. Convert a lat/long pair into a timezone, and
  2. Determine the daylight savings offset for a given timezone and a date.

I imagine I need some function for (1) and a database of values for (2), but I do not know where I can get these, or if they are freely available.

Other constraints:

UPDATE: Thanks to all those who provided answers so far. I am currently trying to tackle this problem by using the GeoNames data and performing a nearest-neighbor calculation to determine a timezone from a lat/long, and will focus on using Joda Time and the associated latest tz database for computing daylight savings offsets for particular dates.

Upvotes: 0

Views: 626

Answers (2)

Michael Rutherfurd
Michael Rutherfurd

Reputation: 14045

Just a dumb question... are you sure that the timestamps you have aren't in GMT/Z/UTC already. That seems more logical if this data is from a single source, or even multiple similar sources. If so a fair bit of your problem just disappeared.

If the data is from a collection of static sites (i.e. weather stations) then you can use one of the suggested web services to look up the timezone and then cache the result locally. Admittedly, daylight savings may cause issues with this as the timezone would change dependent on the date.

Upvotes: 1

Jon Skeet
Jon Skeet

Reputation: 1499840

Once you've got a time zone, you don't need to perform the DST checking yourself - the Java TimeZone, Joda Time DateTimeZone and .NET TimeZoneInfo classes will take care of that for you.

(If you're using Java, I'd strongly recommend using Joda Time instead of the built-in calendar classes.)

I don't know of any libraries to convert a lat/long to a time zone, I'm afraid. I'm sure there must be something available, but I don't know it offhand. Note that any such library is likely to give you a zoneinfo style name (e.g. "Europe/London") which isn't what the .NET TimeZoneInfo class uses, unfortunately. If Noda Time were ready, I'd suggest using that instead of .NET, but we haven't finished it yet :(

Upvotes: 2

Related Questions