Message-Id: <10646.118970@fatcity.com> From: "Eric Lansu" Date: Wed, 11 Oct 2000 15:59:46 +0200 Subject: Re: How many days until Christmas? This is a multi-part message in MIME format. ------=_NextPart_000_098D_01C0339C.473738D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable It looks like Christmas is a popular issue, I haven't seen this many = reply's on a question like this in a long time! Eric Lansu ----- Original Message -----=20 From: Mark Leith=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, 11 October 2000 14:00 Subject: How many days until Christmas? Hi Guy's =20 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? =20 Don't ask me why, mine is just to do and die..=20 =20 Thanks =20 Mark =20 Mark Leith =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Cool Tools UK Ltd +44 1905 330 281 mark@cool-tools.co.uk ------=_NextPart_000_098D_01C0339C.473738D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
It looks like Christmas is a popular = issue, I=20 haven't seen this many reply's on a question like this in a long=20 time!
 
Eric Lansu
----- Original Message -----
From:=20 Mark=20 Leith
To: Multiple recipients of list ORACLE-L =
Sent: Wednesday, 11 October = 2000=20 14:00
Subject: How many days until=20 Christmas?

Hi=20 Guy's
 
I've = been asked a=20 question, but haven't the time to check it, so I'm sorry if its = simple. Is=20 there a way of finding the difference in days between sysdate (today) = and a=20 point in time in the future (Christmas) through = Oracle?
 
Don't ask me why,=20 mine is just to do and die..
 
Thanks
 
Mark
 
Mark Leith
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=
Cool Tools UK=20 Ltd
+44 1905 330 = 281
mark@cool-tools.co.uk