Date Query
Posted by: Jay Balan
Date: October 06, 2006 02:00PM

Hi

I have a table with 12 "expiry date: columns for different tickets. How can I do a query that would select all the expiry date columns that would include all dates less than today and also include 90 days in the future. I can't use multiple ANDS or OR's any suggestions?

Options: ReplyQuote


Subject
Written By
Posted
Date Query
October 06, 2006 02:00PM
October 06, 2006 06:44PM
October 10, 2006 09:37AM
October 10, 2006 09:58AM
October 10, 2006 10:54AM
October 10, 2006 11:12AM
October 10, 2006 11:17AM
October 10, 2006 11:28AM
October 10, 2006 11:44AM
October 10, 2006 11:57AM
October 12, 2006 08:46AM
October 13, 2006 09:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.