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
When you are using SQL connected to the server (mysql -ublah) the timestamp
is the server one. If you use app time functions it will be client time.
Bottom line: use server sql functions.
Ciao
Claudio
Il giorno 4 lug, 2009 8:50 m., "Nathan Huang"
ha scritto:
Hi guys
I am going to fetch out the
Hi guys
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 say I set the date and send itto remote ser
