List:General Discussion« Previous MessageNext Message »
From:Michael Stroh Date:October 23 2013 2:20am
Subject:Re: Date comparison help
View as plain text  
Thanks Sam.

It turns out that if I put the DATE_ADD.. within DATE(), it works as expected. That is
sufficient for my goals, but it would be nice to understand this issue in case there may
be other cases that I need to watch out for.

Cheers,
Michael



On Oct 22, 2013, at 6:18 PM, kitlenv <kitlenv@stripped> wrote:

> Hi Michael,
> 
> FYI: I'm using 5.6.13 and your query returns 0 for the third column with my instance.
> 
> 
> Cheers,
> Sam
> 
> 
> On Wed, Oct 23, 2013 at 2:35 AM, Michael Stroh <stroh@stripped> wrote:
> I recently upgraded a local MySQL installation to 5.5.32 and am trying to figure out
> why the following query won't work as expected anymore. I'm just trying to compare a set
> of dates to NOW() but since the upgrade, these don't seem to work as expected.
> 
> SELECT
> DATE_ADD(STR_TO_DATE('2013-350-00:00:00','%Y-%j-%H:%i:%S'),INTERVAL 2 DAY),
> NOW(),
> DATE_ADD(STR_TO_DATE('2013-350-00:00:00','%Y-%j-%H:%i:%S'),INTERVAL 2 DAY)<NOW()
> 
> For instance, when I run it on my system, I get 1 for the third column even though
> comparing the two by eye it should be false.
> 
> Cheers,
> Michael
> 
> 
> 


Thread
Date comparison helpMichael Stroh22 Oct
  • Re: Date comparison helpkitlenv22 Oct
    • Re: Date comparison helpMichael Stroh23 Oct
Re: Date comparison helphsv23 Oct