in reply to Detecting 1 day ago

I agree have mysql do it! Too bad you're using an inferior database otherwise it would be as simple as datecol < now() + "1 day ago"::interval


Evan Carroll
www.EvanCarroll.com

Replies are listed 'Best First'.
Re^2: Detecting 1 day ago
by graff (Chancellor) on Feb 25, 2006 at 18:57 UTC
    I'll grant the MySQL is arguably less capable than some older established servers, but it's respectably simple for the task at hand: 
    select count(*) from mytable where TO_DAYS(datecol) > TO_DAYS(NOW()) -
+ 1

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom