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
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.