List:General Discussion« Previous MessageNext Message »
From:Michael Stroh Date:October 22 2013 3:35pm
Subject:Date comparison help
View as plain text  
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