How to get GMT in ASP

I have a database that is used across the country within the company I work with.  I have a search page the searches area codes and returns all matching area codes with the current time in that area code.  

I would take the server time, but unfortunately, the site is located on a few servers to balance the load and some of the servers are not located in the same timezone as the others.

Is there anyway to have the server calculate GMT and use that as the basis of the time calculation, or do I have to get the local time from the client and then calculate it that way?  I can't believe that there isnt anyway to do this from the server.  Please help!
jerf26134Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

hongjunCommented:
Check this out

<script language="JSCRIPT" runat="SERVER">
  //this is jscript
   function getTimezoneOffset() {
         var dtmNow = new Date();
         var intOffset = dtmNow.getTimezoneOffset() / 60
         intOffset = -(intOffset +1)
         return(intOffset);
    }
</script>
<%
   'this is vbscript
   response.write formatdatetime(dateadd("h",getTimezoneOffset,Now),3)
%>


hongjun

Experts Exchange Solution brought to you by

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
jerf26134Author Commented:
Maybe it's too late at night for me, but all I get when I try it is a type mismatch:

Type mismatch: '[string: "function getTimezone"]'

I had it write the variable getTimezoneOffset and it returned the whole script as a string instead of a time:
function getTimezoneOffset() { var dtmNow = new Date(); var intOffset = dtmNow.getTimezoneOffset() / 60 intOffset = -(intOffset +1) return(intOffset); }

Any ideas on what I might be doing wrong?  It could just be because its late for me and I am not thinking straight.
jerf26134Author Commented:
Ok, I got it working with some tweaking.  Here is the final answer I came to in case anyone is looking for it in the future:

time.asp --
<script language="jscript" runat="server">
   d = new Date();
   tz = -d.getTimezoneOffset()/60;
</script>

<%
gmtime = DateAdd("h",tz,now)
gmtime = FormatDateTime(gmtime, 3)

response.write gmtime
%>
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.