Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How many days until Christmas?

Re: How many days until Christmas?

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Wed, 11 Oct 2000 15:59:46 +0200
Message-Id: <10646.118970@fatcity.com>


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

  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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US