indranilkamulkar try to set the timezone based on the difference in time you are seeing.
Time Zome / time Issue
Facing the same issue.. In the DB,time is proper.. Issue is only with the displaying in the OSTICKET Frontend.
Is your Agent Profile timezone incorrect?
ntozier Yes, my agent profile is also set to IST ( Indian standard time).
The problem is actually with PHP's native timezone_name_from_abbr() method. When passing 'IST' to this method it returns 'Asia/Jerusalem' like we see in all these cases. Seems like this needs to be addressed on their level. I can create a patch to temporarily return 'Asia/Kolkata' instead but this is only a bandaid instead of a permanent fix.
Cheers.
KevinTheJedi The problem is actually with PHP's native timezone_name_from_abbr() method. When passing 'IST' to this method it returns 'Asia/Jerusalem' like we see in all these cases. Seems like this needs to be addressed on their level. I can create a patch to temporarily return 'Asia/Kolkata' instead but this is only a bandaid instead of a permanent fix.
@KevinTheJedi
If you modify the code to:
timezone_name_from_abbr($xxxx,$offset);
It will work fine. I have tested this.
We don’t have an $offset variable and how would we know what each offset will be for each timezone?
Cheers.
KevinTheJedi
Either the user will have to set the offset.
Where is OST getting abbreviated timezone from?
Can OST rely on full timezone instead of abbreviated tz?
The abbreviated time zone is coming from MySQL (@@GLOBAL.system_time_zone).
I will get back to you on the exact reason why we translate the abbreviations to full names.
Cheers.
For me, SELECT @@global.time_zone shows "SYSTEM" & not IST
This brings me to the command echo date_default_timezone_get(); and it shows "Asia/Kolkata"
I'm following this thread on stackoverflow:
https://stackoverflow.com/questions/2934258/how-do-i-get-the-current-time-zone-of-mysql
Would it be better to use the timezone selection by the user so get past this issue in the simplest possible way, without having to rely on external parties like MySQL or PHP etc?
2 years later
rsclmumbai Did you find the solution. I am facing exactly the same problem. If you fond any solution please let me know.
kalepranali044 I had to tweak the time zone to match the timezone of my users.
My users are in IST time zone (+5.30) but I had to select ""Athens"" at the timezone for the time to match accurately.
HTH