BFanguy
asked on
SQL table date/time stored in UTC, need Access function to convert to local date / time
I have a database that has all of the dates / time fields stored in UTC time. I need a function in access to display the date / time based on the local time zone.
Example: in sql i have a date / time stored for a change to a record and it is 5 hours ahead of my local time.
in sql 9/4/2012 5:15:27 PM I'd like to view this in
access in central time (GMT -6) - 9/4/2012 12:15:27PM
Thank you in advance.
Example: in sql i have a date / time stored for a change to a record and it is 5 hours ahead of my local time.
in sql 9/4/2012 5:15:27 PM I'd like to view this in
access in central time (GMT -6) - 9/4/2012 12:15:27PM
Thank you in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys, I will try all 3 solutions.
You are welcome!
/gustav
/gustav
ASKER
DateAdd("h",-5,[Date])
does this take care of daylight savings time.....