List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:June 20 2011 5:11pm
Subject:RE: SELECT records less than 15 minutes old
View as plain text  
>-----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




Thread
SELECT records less than 15 minutes oldsono-io19 Jun
  • Re: SELECT records less than 15 minutes oldClaudio Nanni19 Jun
    • Re: SELECT records less than 15 minutes oldsono-io19 Jun
      • Re: SELECT records less than 15 minutes oldwalter harms20 Jun
        • RE: SELECT records less than 15 minutes oldJerry Schwartz20 Jun
          • Re: SELECT records less than 15 minutes oldsono-io21 Jun
            • Re: SELECT records less than 15 minutes oldwalter harms21 Jun
            • RE: SELECT records less than 15 minutes oldJerry Schwartz21 Jun