From: Michael Dykman Date: July 4 2009 2:26pm Subject: Re: how to get the timestamp from remote mysql List-Archive: http://lists.mysql.com/mysql/218037 Message-Id: <814b9a820907040726k3b035c7bsf7466e0ec8a55142@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 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=mdykman@stripped > > -- - michael dykman - mdykman@stripped - All models are wrong. Some models are useful.