Case Date/Time in Database is different from Case display..

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • murugappan
    Active Community Member
    • Aug 2017
    • 467
    #1

    Case Date/Time in Database is different from Case display..

    Hi,

    Refering to Screencap1, the case detail show the time created as 10.35pm but the record in database (Screencap 2) shows it is create at 14:35 which 2:35pm. The stream data in the Note also captured the time as 14:35. The timezone in the CRM was set as "Asia\Kuala Lumpur" (Screencap 3). The timezone set in PHP in the host server appears to correctly set for ""Asia\Kuala Lumpur" (Screencap 4 and 5).

    Need help on this urgently as our reporting seems to be inconsistent and may be affecting our workflow in the Advance Pack as well.
    Attached Files
    Tags: None
    • yuri
      Member
      • Mar 2014
      • 8440
      #2
      Hi,

      It's stored in UTC. Regardless of php settings.
      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

        • murugappan
          Active Community Member
          • Aug 2017
          • 467
          #3
          Hi,

          Thank you so much. Just needed to confirm. I understand this is done to maintain the universality of the application. Great work.

            Comment

            Previous template Next
            Working...