>-----Original Message-----
>From: walter harms [mailto:wharms@stripped]
>Sent: Monday, June 20, 2011 7:07 AM
>To: sono-io@stripped
>Cc: mysql@stripped
>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
>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: jerry@stripped
Web site: www.the-infoshop.com
