Link to home
Start Free TrialLog in
Avatar of BFanguy
BFanguyFlag for United States of America

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.
Avatar of BFanguy
BFanguy
Flag of United States of America image

ASKER

is this all i need to do?

DateAdd("h",-5,[Date])

does this take care of daylight savings time.....
ASKER CERTIFIED SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BFanguy

ASKER

Thanks guys,  I will try all 3 solutions.
You are welcome!

/gustav