Message-Id: <10646.118957@fatcity.com> From: alex Date: Wed, 11 Oct 2000 13:55:41 +0200 Subject: Re: How many days until Christmas? Hi select round(to_date('24-DEC-00', 'DD-MON-YY')-SYSDATE) from dual; merry xmas > > Hi Guy's > > I've been asked a question, but haven't the time to check it, so I'm sorry > if its simple. Is there a way of finding the difference in days between > sysdate (today) and a point in time in the future (Christmas) through > Oracle? > > Don't ask me why, mine is just to do and die.. > > Thanks > > Mark > > Mark Leith > ================= > Cool Tools UK Ltd > +44 1905 330 281 > mark@cool-tools.co.uk > > ---------------------------------------- Content-Type: text/html; name="unnamed" Content-Transfer-Encoding: quoted-printable Content-Description: ----------------------------------------