Hi all, wondering if anyone can help me out with a mysql query (bit off
topic I know)
select id, title, DATE_FORMAT(auto_enter_date, '%D %b %Y') as date from dci
where auto_enter_date
between ((DATE_SUB(CURDATE(), INTERVAL 90 DAY) and DATE_FORMAT(CURDATE, '%D
%b %Y'));
I want to select the id, title and date between now and the last 3 months,
can anyone show me the correct SQL?
Cheers in advance,
Graeme :)
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
