Try:
Select * from xxx where date between select(add_months('2002-12-31', -4)) and '2002-12-31'
Wayne Schachtel Teradata, a division of NCR
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2003 Indexes