jbaird123
asked on
Using Local Time Zone wtih SQL Server
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?
Thanks
Is this possible? If so,how?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
here is an example from books online
Open in new window