0 Replies Latest reply on Apr 29, 2010 11:40 PM by karthikmm

    DateField from Flex 4 to PHP-mysql

    karthikmm

      Problem :

      when inserting a record from flex to mysql the date is reduced by 1 day.

      changes the date to 1 days ahead..like flex"13/12/2009" to mysql"12/12/2009"

       

      in Flex

      m15.POSTON = pOSTONDateField2.selectedDate;

       

       

      PHP is genereated by Flash Builder ..no changes in that.

      $item->POSTON->toString('YYYY-MM-dd HH:mm:ss')

       

      mySQL works fine.

       

      Here is the interesting bit..when I change my computer location from UTC +10( Australia) to UTC + 0..it works fine.

       

      changed the PHP setting date.timezone ="Australia/Brisbane"

       

      date_default_timezone_set('Australia/Brisbane');

       

      stilll same result..

       

      Why dose this happen how do I fix it.

       

       

      Thanks

      K