howto change MySQL time_zoneby jeanluca (Deacon)
|on Sep 11, 2007 at 08:25 UTC||Need Help??|
jeanluca has asked for the
wisdom of the Perl Monks concerning the following question:
My application does everything in the UTC time. Works great, however I use a field which gets the current time:
which stores time as local time (not UTC)
I tried to change the time_zone like
(also tried UTC)
However the current timestamp is still in local time.
Currently the time_zone is set to 'SYSTEM'. I don't own the database, so I need to change the session TZ!
Any suggestions how to change this ?
Thnx a lot