1 Reply Latest reply on Nov 7, 2011 8:11 PM by tooMuchTrouble

    Timezone formatting issues

    spacehog Level 1

      We are having timezone issues with Flex.  We are using Flex to query our database (via Coldfusion) and then draw a linechart (the dates are the x axis) with the query return. All of our servers and clients are in Pacific time.

       

      From the dateChooser the format going to Coldfusion is the Flex standard UTC (e.g. Thu Jun 23 00:00:00 GMT-0700 2011).  Within Coldfusion we are converting the date to (MM/DD/YYYY) and the query return the date as MM/DD/YYYY HH:mm:ss.  From a cfm page the date reads correctly.  From Flex the date will be 7 or 8 hours ahead (depends on DST).  How do we get the Flex objects to read the date we are passing in exactly as it is? and not converted to GMT?

       

      Example

       

      Correct Date 6/23/2011 00:00:00 will show on the graph as 6/23/2011 07:00:00

        • 1. Re: Timezone formatting issues
          tooMuchTrouble Level 3

          On 11/8/2011 4:19 AM, spacehog said:

          query return. All of our servers and clients are in Pacific time.

           

          either the client or the server's not in that tz or you're "over-compensating"

          the UTC offset. for datetimes always in client tz we pass epoch offsets back &

          forth. cf side, you can use the "undocumented" getTime() method on your datetime

          objects (someDateTimeVar.getTime() for instance). and this function should

          convert epoch offset to cf datetime.

           

           

           

          cf datetimes will always be in server tz, you can't change that so stick w/epoch

          offsets.

           

          flex side is simple:

           

          fromEpochDate=new Date(epochOffset);

          epochOffset=someFlexDateTime.getTime();