Incorrect entity creation time in the DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Exsto
    Member
    • Nov 2018
    • 58

    Incorrect entity creation time in the DB

    Hi,
    when I create an entity the creation time is correct while in the database it is an hour back. Because?
    Thanks
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hello,
    it is because of different timezones. Your EspoCRM configured to your timezone and your DB configured to another one (I think it is UTC timezone).

    Comment

    • yuri
      Member
      • Mar 2014
      • 8669

      #3
      We don't use timezones in database. It's always stored in UTC.
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment

      • Exsto
        Member
        • Nov 2018
        • 58

        #4
        Hi,
        I give other indications: if I insert the entity (Lead) from the crm, the time in the DB is -1; while if I insert the lead directly from the DB and automatically generate the date in the created_at field, then it is correct.

        Comment

        Working...