[Vtigercrm-developers] created time > today

[Rubén A. Estrada Orozco]

If you have users in different timezones, I don't see what difference it
would make to have your db in UTC vs anything else. Why do you think it
would be better to stick to UTC, Alan?

When all your users are in the same time zone (in the case of my clients
that's almost always the case), then I like to see the exact same values
when I do a query vs when I see the value displayed in the UI. It's easier
for my brain ;)

Saludos

Rubén


On Fri, Jul 29, 2022 at 4:27 PM Alan Lord <alanslists at gmail.com> wrote:

> On 29/07/2022 16:41, Rubén A. Estrada Orozco wrote:
>
> > When possible, use the same timezone in config.inc.php and in the
> > usrers' calendar config.
>
> Oooh - I think this is wrong advice.
>
> It's not a good idea if you have users in different timezones.
>
> Everything _should_ be stored on the db as UTC. Then all users see the
> correct time *if* their profile is configured correctly.
>
> This issue sounds like maybe there is an issue with either timezone
> conversion in the list filter, or a DATETIME / DATE conversion - meaning
> the hours are being lost or added...
>
> Al
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220729/c5c9358f/attachment.html>