I agree that the best solution is to store all datetimes in UTC time and convert to whichever time zone you want for presenting it. As SQL Server 2000 does not have all the necessary functions needed to do this, your developers will have to write additional code for formatting dates and you will also have to know each user's time zone. If developing in Microsoft.NET then the SimpleTimeZone solution developed by Michael Brumm (http://www.michaelbrumm.com/simpletimezone.html) may be of use.

In your example the two countries are in time zones whose offset is hours different to UTC. However, not all time zones are hours different. For example, India is UTC +4.5 hours. So it would be better to compare datetimes in minutes and not hours.

Keith