List:General Discussion« Previous MessageNext Message »
From:walter harms Date:June 20 2011 11:06am
Subject:Re: SELECT records less than 15 minutes old
View as plain text  

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
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