I have a date field in an SQL Server 2005 table, and the date is in GMT. I would like to convert this date field to the local time zone of the user in a SELECT statement. Currently, all users are on EST, but I would like the flexibility to create this select statement so that if a user on another timezone (PST for example) runs the same query, it will return the date/time in PST.
Is this possible? If so,how?