Wrong time In Date created

 
1
0
-1

Hello,

I have a Datalist on my joget app, created with columns from a form. I have also added Date created in the datalist.

The problem is that Date created shows right date but wrong time. It is always 1 hour before real time. I have set the same Time zone in system settings and also in user settings. In database I can see the the time is right,

Please help!

Thanks

    CommentAdd your comment...

    4 answers

    1.  
      1
      0
      -1

      In your date picker, choose UTC. This will make sure the date/time is accurate regardless of DST or not.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        The datetime stored inside DB should not point to a timezone that changes at different time of the year (a concept we call a single source of truth)

        This is so that the recipient can translate to the local timezone easily.

        If the datetime in DB observes DST sometimes and sometimes not, this would make translating to local timezone unnecessarily complex.

        It should point to UTC. Read more https://blog.invertedsoftware.com/2018/08/14/youre-doing-it-wrong-stop-making-a-mess-out-of-your-apps-time-zones-with-utc/

          CommentAdd your comment...
        1.  
          1
          0
          -1

          Nobody has any suggestion on this issue?

            CommentAdd your comment...
          1.  
            1
            0
            -1

            Which timezone you are in? Maybe there is DST going on in your area and you will need to select the timezone with DST observed.

            1. genti

              I am in CEST time zone. Date on server is ok, so it should be right time zone. Date on database is the right one as well. At the end of March there was the official change in time. Maybe the problem is since then, but because database and server have the right time, I am not sure where joget is taking its time. I am now noticing that in the options for selecting time zones in joget for Rome, it is showing GMT +1 but it should be GMT +2 since end of March. I don't understand why joget is still showing option for winter time. The problem is if i select GMT +2 I get right time, but I get wrong time for records before end of March.

            CommentAdd your comment...