Posted by 427SOHC on 06/23/06 07:01

In article <1150970609.653300.44400@r2g2000cwb.googlegroups.com>, monomaniac21
says...
>
>can you write a mysql qery to retrieve all rows from a table where the
>date collumn is equal to a value (date) from now to 30 days ago?
>

Maybe something like


SELECT * FROM table WHERE date >= 'today'::date - '30 days'::interval;


--
Unlimited Newsgroup Download Day
Newsguy Bandwidth Blowout 6-29-06
More Info - http://www.newsguy.com/nolimits.htm

• Next in forum: Re: refresh problem
• Prev in forum: Re: [an error occurred while processing this directive] ???
• Thread view: Re: mysql query to get rec's created in last 30 days

[Reply to this message]