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