Assuming that synchornizing the clocks between the systems is beyond
your control you could try getting the UTC timestamp from both
systems, then adjust your date/time math according to the difference
between them.
> select unix_timestamp(utc_timestamp());
It is more than a little hacky, but it
On 4 Jul 2009, at 07:48, Nathan Huang wrote:
I am going to fetch out the data from remote mysql database
according to timestamps colmmen, however my local date is different
from the one on remote mysql database,
how can I get right timestamp using the date of remote time zone?
that is to sa
