Android Question RDC and time zone

Discussion in 'Android Questions' started by Harris, May 2, 2015.

  1. Harris

    Harris Well-Known Member Licensed User

    When inserting records with RDC, does it provide the local time zone for the current session?

    Using MySQL
    In my B4A app, I convert my DateTime fields to ISO8601 simple format (2014-05-02 14:31:01) to insert into a TIMESTAMP field on my server. Both PHP and MySQL server zone are set to UTC.

    MySQL docs state that TIMESTAMP type will take the data provided and convert it to UTC for storage. Then when selecting from web client, data will be converted back to whatever the connected client's timezone is. DATETIME type does not provide this function.

    When I view posted data using MyphpAdmin, the Timestamp fields show the exactly what I posted - and not the offset (-07:00) as I would expect??? That is why I asked if sessions time zone offset it known. EDIT: phpAdmin is providing the same (-7) time zone offest... duh..

    When submitting dates, should I first convert the date to UTC or just submit it as local time?

    Very confused...

    Thanks
     
    Last edited: May 3, 2015
  2. Erel

    Erel Administrator Staff Member Licensed User

    RDC doesn't modify the data in any way. It is up to you to decide which exact data should be stored.
     
  3. Harris

    Harris Well-Known Member Licensed User

    Thanks Erel. I know it doesn't modify data, just wondered if MySQL knew what the timezone was of the client that sent the data to RDC (I think it does).
    I shall experiment some more and report back.
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    MySQL doesn't know anything about the client.
     
  5. Harris

    Harris Well-Known Member Licensed User

    DonManfred likes this.
  6. Erel

    Erel Administrator Staff Member Licensed User

    The MySQL server will treat RDC as the client. So the session timeout (if it is indeed used) will be RDC time zone.
     
    DonManfred likes this.
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice