>From: walter harms [mailto:wharms@stripped]
>Sent: Monday, June 20, 2011 7:07 AM
>Subject: Re: SELECT records less than 15 minutes old
>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
>statement works properly.
>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.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com