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!