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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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