Default Time Zone: UTC?

Hi again,

Busy times...

When saving an item, flexicontent always save in the database with UTC time.

We need to use UTC -1
Despict the way I configure PHP or MySQL the result is always the same. Time saved with UTC.

Is this a Flexi default behavior?
If yes, how can we overcome this issue?

Thanks in advance for any help

you can use override time in joomla configuration and use same for field

In short it is better not to do it.

Joomla also stores UTC, and in general all DBs recommend saving UTC ...

Instead it is better to do this
1. adjust you SQL queries to achieve desired result e.g. using DATE_ADD() function
2. format the output of the displayed date to be displayed in desirable timezone

Thanks ggppdk I can live with that.
But I cant understand why the possibility to add time offset to joomla time, long asked feature, its so difficult for joomla devs?

For me this is really funny :shock:

The offset can be used when date is displayed, not sure why this would be necessary for DB too,

it is better to only store UTC and do the customization display at PHP when displaying,

ggppdk wrote: The offset can be used when date is displayed, not sure why this would be necessary for DB too,

it is better to only store UTC and do the customization display at PHP when displaying,

I agree... but still cant understand why is so difficult to implement an offset as joomla parameter!?

As example, I preferred to not mess around with code and change my time zone to Atlantic/Azores(UTC -1) and I know that I've to change again when Daylight Saving Time changes to summer time.
If you ask me, joomla devs don't care a dam(with all my respect) if this is user friendly or not.