mktime() question

[ptbsG_Man]

Hello i want to create a SQL call to grab news post from now to 30 days ago must i have no real good understanding of mktime but i know thats what i need to use to do this ... heres what i have to work with.

the DB has a date filed and the format is mm/dd/yyyy and i was going to use something like

SELECT * FROM news
WHERE Date
BETWEEN date("m/d/Y") AND mktime(i dunno)

any one have something yo do this

thanks Don

[devinemke]

what RDBMS are you using? if mySQL then do something like:

SELECT * FROM news WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Date

read up on Date and Time Functions

[ptbsG_Man]

im using SQLite but i found a way to do it after posting ... i always do that.. but using

$prevdate = date("m/d/Y", strtotime("-30 day")) works

ill keep the MySQl thing in mind

Thanks.