Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Date in SQL

Date in SQL

From: Marien Kaptein <m.kaptein_at_optimit.nospam.nl>
Date: Wed, 28 Jul 1999 09:31:51 +0200
Message-ID: <7nmb8k$ph6$1@news.tue.nl> 





Hi all,



I have a table with a date field. From this table I want to list all records
of which the date is 15 days old, thus the date in the table must be 15 days
before sysdate.



I have tried something with adding days to the day-number and compare this
with last_day. But this gets to complex because you must also account for
situations where you cross months and years.



Has anyone any idears?



Thanx in advance


Marien Kaptein


Received on Wed Jul 28 1999 - 02:31:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US