Re: Date in SQL

From: Philippe <parnaud_at_yahoo.com>
Date: Wed, 28 Jul 1999 09:39:29 +0200
Message-ID: <7nmc43$ut$1@concorde.ctp.com>

Try select * from YourTable where trunc(sysdate) - trunc(colDate) <= 15

HTH,
Philippe

Marien Kaptein wrote in message <7nmb8k$ph6$1_at_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:39:29 CDT