Avatar of David Bach
David BachFlag for United States of America

asked on 

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
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Anthony Perkins
Avatar of jmoss111
jmoss111
Flag of United States of America image

Hi Veriman,

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
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Microsoft SQL Server 2005
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo