From: walter harms
Date: June 20 2011 11:06am
Subject: Re: SELECT records less than 15 minutes old
List-Archive: http://lists.mysql.com/mysql/225305
Message-Id: <4DFF29C6.5090501@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit



Am 19.06.2011 21:06, schrieb sono-io@stripped:
> 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.

re,
 wh