>-----Original Message----- >From: walter harms [mailto:wha...@bfs.de] >Sent: Monday, June 20, 2011 7:07 AM >To: sono...@fannullone.us >Cc: mysql@lists.mysql.com >Subject: Re: SELECT records less than 15 minutes old > > > >Am 19.06.2011 21:06, schrieb sono...@fannullone.us: >> On Jun 19, 2011, at 11:11 AM, Claudio Nanni wrote: >> >>> just a quick debug: >> >> Thanks, Claudio. It turned out to be that NOW() was using the server's >time and my timestamp was based on my timezone. After fixing that, the >SELECT >statement works properly. >> >> Marc > >You should use UTC time zone or you will run into trouble with DST. > [JS] If you do that, you can't use an automatic timestamp field. You have to set the field yourself.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
