Is anyone using sql in the phpadmin front-end to query data in Mariadb?
I’m looking to be able to report data from a HA system running in another timezone. I want the dates to be reported in that HA system’s timezone not my timezone.
In sqlite all I had to do was use datetime(last_changed,‘localtime’)
What is the equivalent for mariadb ?
you should be able to set client (your application) timezone issuing sql command. then the time will be converted on the fly.
see https://mariadb.com/kb/en/time-zones/
But don’t know how phpAdmin manage that.
I drop this app 20 years ago due to its limitations in favor of dedicated desktop clients, initially the ones bundled with mysql but after discontinued I was happy using HeidiSQL or recently DBeaver
I suspect phpAdmin provides a setting to achieve that