Using Transact SQL To Convert From GMT to Local Time
Greetings;
I've stored a date and time in GMT on a given SQL 2005 table.
I need to know if there is an enumeration or other SQL 2005 object which will allow me to return from a SELECT statement the date and time stored as GMT in the user's date and time. Hopefully, the enumeration, if one exists, will know if and when daylight savings time starts and stops for the user's time zone.
Is there a way to do this?
Much thanks for your assistance ... David
I've stored a date and time in GMT on a given SQL 2005 table.
I need to know if there is an enumeration or other SQL 2005 object which will allow me to return from a SELECT statement the date and time stored as GMT in the user's date and time. Hopefully, the enumeration, if one exists, will know if and when daylight savings time starts and stops for the user's time zone.
Is there a way to do this?
Much thanks for your assistance ... David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I was looking for a similar solution but haven't implemented it yet. See: http://www.codeproject.com/KB/database/ConvertUTCToLocal.aspx?display=Print
The files are attached.
Regards,
Jim
UTCToLocal-Data.zip