Dreamhost is in GMT -7, while I´m in GMT -3 (Brazil).
I´ve given up adjusting another timezone just for me (it´s a shared hosting plan), as dreamhost staff said the .my.cnf wouldn´t work for that. So now I´m resignated to setting offset with Perl, before recording the ‘datetime’ columns.
But my problem is the ‘timestamp’ fields, on wich automatic recording relies my code. I tried setting the default of this ‘timestamp’ column to CURRENT_TIMESTAMP + interval 4 hour but this formula isn´t accepted by mysql as a default, not even between quotes, paranthesis or anything. The now() + interval 4 hour won´t work either.
So, before I convert them all to ‘datetime’ and make my sql statements act as a nanny when all I need is a timestamp behavior, I´d like to hear from you guys if you know about some work around for that.
Thanks a lot