List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:July 4 2009 2:26pm
Subject:Re: how to get the timestamp from remote mysql
View as plain text  
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 will work

 - michael dykman


On Sat, Jul 4, 2009 at 2:48 AM, Nathan
Huang<nathan.vorbei.tech@stripped> wrote:
> 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 server or database to calculate
>  timestamps of it
> thanks in advance
> nathan
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.
Thread
how to get the timestamp from remote mysqlNathan Huang4 Jul
  • Re: how to get the timestamp from remote mysqlMarcus Bointon4 Jul
  • Re: how to get the timestamp from remote mysqlMichael Dykman4 Jul