I want to find out what will 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...
A:
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?
Tobiasopdenbrouw
2010-07-29 07:29:05
Answered, but not upvoted. Curious. :)
Tobiasopdenbrouw
2010-07-29 09:54:53
+1
A:
.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.
Dean Harding
2010-07-29 07:30:09
A:
You might want to look at the method:
TimeZoneInfo.ConvertTime
Martin Ingvar Kofoed Jensen
2010-07-29 07:31:23