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.
BFanguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
BFanguyAuthor Commented:
is this all i need to do?

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

does this take care of daylight savings time.....
0
 
hnasrCommented:
This just subtracts 5 hours from date.

Daylight savings has to be managed in the original data captured.

You can check by listing few values including Daylight savings entries.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Gustav BrockCIOCommented:
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
lwadwellCommented:
I tried the functions from here http://www.vbusers.com/code/codeget.asp?PostID=1&ThreadID=632

They seem to work fine in doing a local->UTC (GMT) and back based on limited testing by just doing:
select now() as current_time, ConvertLocalToGMT(now()), ConvertGMTToLocal(now()), datediff("h", ConvertLocalToGMT(now()), now()),  datediff("h", ConvertGMTToLocal(now()), now())
0
 
BFanguyAuthor Commented:
Thanks guys,  I will try all 3 solutions.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.