"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1167832817.316730.194960@s34g2000cwa.googlegr oups.com...
>
> Sean wrote:
>
>> I think that it would be better with
>>
>> SELECT * FROM mytable WHERE date > adddate(sysdate(), -60)
>>
>> Which is a spin off from "date_add(date, -60, DAY)"
>>
>> You can swap DAY for anything like:
>>
>> MICROSECOND
>> SECOND
>> MINUTE
>> HOUR
>> DAY
>> WEEK
>> MONTH
>> QUARTER
>> YEAR
>>
>>
>> Hope that helps.
>>
> Why would it be better?
> And why wouldn't you use subdate rather than adddate with a negative
> argument?
>

Sorry, you're right.

I was implying that this would be a better option than SYSDATE()-INTERVAL 60
DAY and overlooked "sub_date", which of course makes even more sense.

SA