Hello!
Tell me please how does date and time works in Zammad.
A new ticket creats in system at 11:06 oclock (it’s correct and the same time as real time in region).
screenshot:
current time in DB is the same as “real time” too:
screenshot
But if I will do select to DB I see that created_at is less for 3 hour then current time (than real created time)
screenshot
Is it the way to make Zammad to show “real time” in DB and not minus 3 hours as Zammad show it now
I’m new to Zammad, but that looks like the database is storing times in UTC and displaying them in local time (+3 according to your second screenshot).
It always trips me up with other applications where I’m querying the database directly 
Hi! thanx for answer… so is there the way to show the correct time? or just using something like that “create_at + interval ‘3 hours’”
I’ll have to leave that for someone else, I’m afraid, as I’m still finding my way around it. Possibly not, but that’s a guess.
This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.
