Re: How many days until Christmas?

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Wed, 11 Oct 2000 14:17:06 +0200
Message-Id: <10646.118959@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0912_01C0338D.EF6F0690 Content-Type: text/plain;

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

1 select trunc(to_date('25/12/2000','dd/mm/yyyy') -sysdate) days 2* from dual
pike [BENE] SQL> /

DAYS

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_0912_01C0338D.EF6F0690 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>  1  select=20
trunc(to_date('25/12/2000','dd/mm/yyyy') -sysdate) days<BR>  2* = from=20
dual<BR>pike [BENE] SQL> /</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>    =20
DAYS<BR>---------<BR>       = 74</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 - 07:17:06 CDT