Posted on 2006-04-22
Last Modified: 2013-12-24
My web host in in USA, but the majority of my web users are in the UK. They post on forums, and so on which are date stamped using NOW(). Obviously the times are taken from the US server.

Is there a command that I can use in application.cfm (set locale manybe), or something I can do to alter all times added to GMT without having to add a line of code to remove the 6 hours from ever date submitted.

The main reason is that eventually I will be moving to a dedicated server in the uK and I dont want to have to find all this code and change back

Question by:mvwmail
    LVL 7

    Accepted Solution

    Use this function to get UTC independent of the location of your host server:


    Name:         GetNISTTime()

    Author:         Ben Forta, 12/6/2005

    Description:   Obtains current time data from NIST
                Internet Time Service servers.

                DST:      US daylight savings time flag.
                HEALTHY:   TRUE if time server is healthy, FALSE if not.
                JULIAN:      Last 5 digits of Julian date/time value.
                LEAPMONTH:   TRUE is second will be added to or subtracted
                         from the current month.
                MSADV:      Number of milliseconds advanced by server to
                         compensate for network latency.
                NOW:      Current date/time.
                RAW:      Raw data from time server.
                SUCCESS:   TRUE if worked, FALSE if not, check
                         this flag first.

    Note:         For a list of NIST time servers see:
                Servers should be addressed via IP address rather than
                host name. The server used here is
                (, but any of the listed servers will work.
                To use an alternate server, just specify the IP
                address in timeServer variable.

    <cffunction name="GetNISTTime" returntype="struct" output="false">
       <cfset var timeServer="">
       <cfset var result=StructNew()>

       <!--- Try/catch block --->

          <!--- Try get time data --->
          <cfhttp url="http://#timeServer#:13/" />
          <!--- Save raw data --->
          <cfset result.raw = CFHTTP.FileContent>
          <!--- Extract Julian date --->
          <cfset result.julian=ListGetAt(result.raw, 1, " ")>
          <!--- Extract current date and time --->
          <cfset, 2, " ")
                                  & " "
                                  & ListGetAt(result.raw, 3, " "))>
          <!--- Extract daylight savings time flag --->
          <cfset result.dst=IIf(ListGetAt(result.raw, 4, " ") IS 0,
                            FALSE, TRUE)>
          <!--- Extract leap month flag --->
          <cfset result.leapmonth=IIf(ListGetAt(result.raw, 5, " ") IS 0,
                               FALSE, TRUE)>
          <!--- Extract health flag --->
          <cfset result.healthy=IIf(ListGetAt(result.raw, 6, " ") IS 0,
                               FALSE, TRUE)>
          <!--- Extract advance milliseconds --->
          <cfset result.msadv=ListGetAt(result.raw, 7, " ")>
          <!--- Success --->
          <cfset result.success=TRUE>

          <!--- Catch any errors --->
          <cfcatch type="any">
             <cfset result.success=FALSE>


       <cfreturn result>

    LVL 3

    Author Comment

    WOAH... gonna have to have a good look at THAT one.. good old Ben F

    I suspect that will work.. will try and come back.

    LVL 3

    Expert Comment

    add follow in application.cfm
    <cfset Newnow = dateadd(H,5,now())>( 5 is a example if the server 5 hour slower)
    then just use Newnow instead of now()

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A web service ( is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
    Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video discusses moving either the default database or any database to a new volume.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now