>I have a date comparison problem that I'm sure is simple enough but I'm just
>not experienced enough to figure it out. I simply want to grab every entry
Um.
First of all, better code would be:
my @now = localtime( );
$now[5] += 1900;
$now[4] += 1;
$currenttime = sprintf( '%04d%02d%02d%02d%02d%
| not experienced enough to figure it out. I simply want to grab every entry
| in a given table that has been entered within the last three days.
select * from yourtable where datefield < date_sub(now(),interval 3 day);
see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html
at
Can you just not use...
...WHERE myDateField > '1997-10-04 22:23:00'
...WHERE myDateField > '1997-10-04'
?
regards,
P
>
> You get the idea... thoughts?
>
> Best,
> Nick
>
>
> -
> Before posting, please check:
>ht
