Re^5: Timezone antidote

Hello hatter and everybody

Thanks for the tips. Specially yours, hatter. But, tell me, any tip for mysql? My problem is the 'timestamp' fields, on wich rely my code and I´d have to convert them all to 'datetime' and make my code treat this offset.

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. I thought then about setting some kind of variable as now() + interval 4 hour but I think it won´t work either.

Any ideas? My host said there´s no way to set a different time_zone through .my.cnf

Thanks

André

Comment on Re^5: Timezone antidote Select or Download Code

Replies are listed 'Best First'.
Re^6: Timezone antidote by hatter (Pilgrim) on Oct 21, 2005 at 13:21 UTC
DATE_ADD(NOW(),INTERVAL 4 hour) would be the option if you're setting itn in your INSERTs, DATE_ADD(CURRENT_TIMESTAMP, INTERVAL 4 hour) may work in the column definition as the default value, if you've not tried that already. `the hatter`	[reply] [d/l]