1 Topic by jung

  • jung
  • Member
  • Offline
  • Registered: 2020-01-08
  • Posts: 91

Topic: How to set the email timestamp from UTC to Ubuntu 20.04 local time?

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: Ubuntu 20.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Dear All,

Email timestamp  from iredapd database>smtp_sessions table is using the UTC time zone which is 3 hours late. How can i replace the UTC time zone with the Ubuntu Local time?

Thanks.
JunG

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: How to set the email timestamp from UTC to Ubuntu 20.04 local time?

We store UTC time in iRedAPD SQL db, you can simply convert it to your local time, but please don't store local time in SQL db.

3 Reply by jung

  • jung
  • Member
  • Offline
  • Registered: 2020-01-08
  • Posts: 91

Re: How to set the email timestamp from UTC to Ubuntu 20.04 local time?

Hi Zhang,

ZhangHuangbin wrote:

We store UTC time in iRedAPD SQL db, you can simply convert it to your local time, but please don't store local time in SQL db.

Thanks.

Jung