Converting datetime column value to server datetime value

Question

I am trying to build a calendar with date time columns. My SP 2007 server is in US and I am trying to use this site in India. My server returns the EventDate column value in India format. I want to convert it in US date.

For example:

---

My Event Date I set is: 5/29/2012 3:00 PM
I want to convert it in: 5/29/2012 2:30 AM (US Time)

Any help will be appreciated.

Answer 1

To convert a datetime to an other timezone in c# you can use this:

TimeZoneInfo timeZoneInfo; 

DateTime dateTime ; 

//Set the time zone information to US Mountain Standard Time 

timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("US Mountain Standard Time"); 

//Get date and time in US Mountain Standard Time 

dateTime = TimeZoneInfo.ConvertTime(DateTime.Now, timeZoneInfo);

//Print out the date and time

Console.WriteLine(dateTime.ToString("yyyy-MM-dd HH-mm-ss")); 

A List of TimeZones and further documentation you can find here:

And in the MSDN: http://msdn.microsoft.com/en-us/library/system.timezoneinfo.getsystemtimezones.aspx

Conversion with XSLT: http://www.xsltfunctions.com/xsl/fn_adjust-datetime-to-timezone.html