Hi,
I need to query some records based on fields of type date, however, it
seems that every dbms' date format is different. In access, you use
#1/1/99#. In oracle, you need to use Jan-1-99. Is there a standard format
for dealing with dates?
I have a set of records with a column called "myDate".
I'm looking for a query that tells the DB to return all records with
"myDate" within 7 days from today. How can I do that? Thank you very much.
Please reply to twong@cmpmail.com.
-Al