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.
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?


does this take care of daylight savings time.....
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.

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:
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.

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())
BFanguyAuthor Commented:
Thanks guys,  I will try all 3 solutions.
Gustav BrockCIOCommented:
You are welcome!

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.