to compare Indian time

I want to find out what will 开发者_Python百科be the time in india when clock tick to 1Am mid night in any other country.. How i will find out that through any means plz help me to find out this this is to fire birthbay mails at 1AM midnight of that resp country...

---

.NET 3.5 added the class TimeZoneInfo which should be able to do want you want. Particularly, the TimeZoneInfo.ConvertTime(DateTime, TimeZoneInfo, TimeZoneInfo) method.

You can also use the TimeZoneInfo.GetSystemTimeZones() method to get the list of time zones that are registered in the system.

---

You might want to look at the method:

TimeZoneInfo.ConvertTime

---

SQL SERVER 2008 would have the DATETIMEOFFSET data type (which includes the time zone) plus functions like SWITCHOFFSET to switch from one timezone offset to another.

What version are you on?