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_at_cool-tools.co.uk
------=_NextPart_000_098D_01C0339C.473738D0
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.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>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!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:mark_at_cool-tools.co.uk" =
title=3Dmark_at_cool-tools.co.uk>Mark=20
Leith</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, 11 October =
2000=20
14:00</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> How many days until=20
Christmas?</DIV>
<DIV><BR></DIV>
<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=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?</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=20
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">
Received on Wed Oct 11 2000 - 08:59:46 CDT