|
|
| Syntactic Confectionery Delight | |
| PerlMonks |
howto change MySQL time_zoneby jeanluca (Deacon) |
| on Sep 11, 2007 at 08:25 UTC ( #638251=perlquestion: print w/ replies, xml ) | Need Help?? |
|
jeanluca has asked for the
wisdom of the Perl Monks concerning the following question:
Dear Monks
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 LuCa
Back to
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||||