how to get the timestamp from remote mysql
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=arch...@jab.org
R: how to get the timestamp from remote mysql
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 nathan.vorbei.t...@gmail.com ha scritto: 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=claudio.na...@gmail.com
Re: how to get the timestamp from remote mysql
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 say I set the date and send itto remote server or database to calculate timestamps of it thanks in advance There is one straightforward solution: only ever keep timestamps in UTC/GMT and correct for time zone / DST when you display them. While that can be confusing sometimes, overall it's a much simpler way of working that storing local times. Marcus -- Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ UK resellers of i...@hand CRM solutions mar...@synchromedia.co.uk | http://www.synchromedia.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: how to get the timestamp from remote mysql
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 Huangnathan.vorbei.t...@gmail.com 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=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org