select
  mydatefield,
  myvaluestuff
from 
  mytable
where
  mydatefield  between (CURRENT_DATE)-90 and CURRENT_DATE