How many days until Christmas?

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 11 Oct 2000 11:55:16 +0100
Message-Id: <10646.118948@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_001D_01C0337A.1EE38DB0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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_at_cool-tools.co.uk

------=_NextPart_000_001D_01C0337A.1EE38DB0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-10102000>Hi=20
Guy's</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-10102000>I've =
been asked a=20
question, but haven't the time to check it, so I'm sorry if its simple. = Is there=20
a way of finding the difference in days between sysdate (today) and a = point in=20
time in the future (Christmas) through Oracle?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-10102000>Don't =
ask me why,=20
mine is just to do and die.. </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000>Mark</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D344432115-10102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0080ff size=3D2><EM>Mark Leith</EM></FONT></DIV>
<DIV><FONT color=3D#ff0000 face=3DArial =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=

<DIV><FONT color=3D#0080ff size=3D2><STRONG>Cool Tools UK =
Ltd</STRONG></FONT></DIV>
<DIV><FONT color=3D#0080ff face=3DArial size=3D2>+44 1905 330 =
281</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20

href=3D"mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></FONT></D= IV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV> </DIV></BLOCKQUOTE></BODY></HTML> Received on Wed Oct 11 2000 - 05:55:16 CDT