Help With Datetime_Stamp

Hi!

I'm trying to do a query in which I am trying to retrieve any data that is less than 90 days old.

At this time I am hardcoding the date to get the results I need.

Here is the code for the query that I have right now:

select artist, ' - ', title
from tracks
where sold not like 'Y'
and category not like 'X'
and category not like 'A'
and category not like 'B'
and datetime_stamp < '04/01/2009'
order by artist;

Any help is appreciated!

Thanks!

re: Help With Datetime_Stamp

Is one way.
Be careful of any time element with the date when comparing.