Server time and local time problem [SOLVED]

I think what you state is a server based Joomla issue, not a component issue. What happens when you post an article? Are the dates correct then?

hakana I think what you state is a server based Joomla issue, not a component issue.

Joomla has no issues what so ever with my settings.

hakana What happens when you post an article? Are the dates correct then?

Yes. Articles are saved in UTC/GMT time in the database.

I spend 2 days checking and double checking this issue with phpMyAdmin, The World Clock – Time Zone Converter and displaying dates in different formats . My findings: Emerald is saving dates not in UTC time but in SGT time.

This is how I add create date to subscription

$db->setQuery("SELECT FROM_UNIXTIME($start)");
$this->ctime = $db->loadResult();

and this is how it is done in com_content

$date = JFactory::getDate();
$this->created = $date->toSql();

Emerald takes time from Mysql and Joomla from PHP.

Why? because we had a lot of problems with time in the past. Different settings. Many people do not understand Time Zone setting in Joomla and use it wrong. So there become a difference between PHP and MySQL time and when in the query we check access to sunscription we use WHERE extime >= NOW() we get wrong result.

What we did is, create time from MySQL and when we compare and check in MySQL query we always get correct result.

I can only suggest you to set Joomla TimeZone setting right. It is not exactly TimeZone. It is more Time offset. I mean Joomla think that your server time is UTC and TimeSone setting just add offset to that time. If your server time alreade +5GMT for example and you set Joomla TimeZone +5 then you get +10 at the end.

Thanks Sergey for explaining.

Changing the Joomla TimeZone would affect the time display of other components too, wouldn't it? So I don't think this is a solution to my problem.

Strangely, Emerald doesn't respect the Joomla TimeZone when it comes to displaying dates. For example, in the Subscription Confirmation Email, the Start and End date are displayed in the MySQL TimeZone, which is very confusing for the end user. The same is true for the Subscription History page and the Sales page.

I think I can adjust the date output via template overrides:

$cdate = new DateTime($item->ctime, new DateTimeZone('SGT'));                                
$cdate->setTimezone(new DateTimeZone('Australia/Adelaide'));
echo $cdate->format('d/m/Y H:i:s T');

I'm not sure how to do this for the emails, though.

May be I have to add separate timezone parameter to Emerald. Or you just make sure your PHP and MySQL in the sime timesone. Or mysql NOW() and php date('Y-n-в H:i:s') are equal.

Sergey May be I have to add separate timezone parameter to Emerald.

That would be ideal, since Emerald has a non Joomls standard way of storing dates. People without the TimeZone issue could leave the parameter empty and I could set a Timezone offset.

Sergey Or you just make sure your PHP and MySQL in the sime timesone.

Already done that through php.ini but this doesn't affect Emerald's time display

Sergey Or mysql NOW() and php date('Y-n-в H:i:s') are equal..

Huh?

I am waiting for you in skype.

Very interesting discussion and important issue.
Screams for a docs article with usecase examples and tips.

Sorry, I always need a "picture" to get my head around things ;)

We have discussed this issue with Sergey before and he fixed the problem. And I checked it and never saw an issue since then. I don't understand how this issue came up again.

Please find the old topic here:
www.mintjoomla.com/support/community-forum/user-item/3923-hakana/52-emerald-9/4616-wrong-sales-time-in-admin-area.html

hakana I don't understand how this issue came up again.

Do you have this issue again on your website?

Sergey has added the option to insert [START+0] in the email template to output the date acoording to the Joomla TimeZone settings. All other dates can be manipulated through the templates. In short: Emerald still saves AND outputs dates in the MySQL timezone but the output can now be adjusted in the templates as well in the emails.

Lab tests have shown that under intense pressure our cerebrums look for a fitting https://survivalhacks.co/beginners-guide-to-fishing-hunting-and-trapping-for-survival/ reaction and in some cases pick some unacceptable one. It is actually similar to deer that freeze in the headlights of a vehicle.

The quantity of individuals that are thinking about endeavour vocation preparing endeavours keeps on ascending with every day. A great many people confronting this thought are just centred around having the option to ensure that their abilities are attractive and that they can get a new line of work upon fulfilment of http://knowledgestech.com/ any educational experience where they set out upon.

This is an excellent article. This is, in my opinion, one of the best posts ever written. Your work is excellent and inspiring. Thank you very much. build now gg

There are many different calculators on the market, but the best one is definitely the calculadora alicia . It has all the features you could possibly need in a calculator, and then some.

Require every one of your long periods of involvement, take a gander at every one of the inquiries you get posed digital marketing by your clients, and transform that into content across the different digital channels.

It seems like you have identified a timezone configuration issue in your Joomla website, and you're right in thinking that storing dates and times in GMT (+0) is a good practice for consistency io games

I would suggest using the TimeZones component and using the action ConvertFromTimeZone (converts datetime from source time zone to destination time zone) when ...Your local time is your system time. Check the timezone in your operating system. The server time you are referring is according to the timezone in your server configuration files.The ToLocalTime method converts a DateTime value from UTC to local time. To convert the time in any designated time zone to local time, use the TimeZoneInfo. Core Ball ConvertTime method. The value returned by the conversion is a DateTime whose Kind property always returns Local.The safest way to make this test reliable and work all around the world is to use a date in your local time zone. You'll not use timestamps to set initial dates anymore. We can enhance the previous rule about timestamps: Rule #2 : String dates are suitable for display using the user's time zone and computations. To convert 18:00 UTC (6:00 p.m.) into your local time, subtract 6 hours, to get 12 noon CST. During daylight saving (summer) time, you would only subtract 5 hours, so 18:00 UTC would convert to 1:00 p.m CDT. Note that the U.S. uses a 12-hour format with a.m. and p.m. Other countries use 24-hour time.

To fix the issue with timezones in Joomla, ensure all database timestamps are stored in UTC for consistency. Adjust the "Server Time Zone" in Joomla’s Global Configuration to UTC and manage polytrack user-facing times using profile or display settings. This approach minimizes discrepancies between stored and displayed times.