RE: How many days until Christmas?

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 11 Oct 2000 16:07:40 +0400
Message-Id: <10646.118960@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

=_NextPart_001_01C0337B.DCCDD0E6 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,
=A0=A0=A0 It looks simple.....
=A0

=A0=A0 SQL> select to_date('25-Dec-00','dd-mon-yy') - sysdate from dual =
;

=A0

TO_DATE('25-DEC-00','DD-MON-YY')-SYSDATE

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 74.331516

HTH,
Rajesh

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Mark Leith Sent: Wednesday, October 11, 2000 4:00 PM To: Multiple recipients of list ORACLE-L Subject: How many days until Christmas?

Hi Guy's
=A0

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?
=A0

Don't ask me why, mine is just to do and die..=20
=A0

Thanks
=A0

Mark
=A0

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

=A0

=_NextPart_001_01C0337B.DCCDD0E6 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 HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20

class=3D039060612-11102000>Hi,</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D039060612-11102000>    It looks=20 simple.....</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D039060612-11102000></SPAN></FONT> </DIV> <DIV><BR><FONT color=3D#0000ff face=3D"Lucida Console" = size=3D2>   SQL>=20
select to_date('25-Dec-00','dd-mon-yy') - sysdate from dual<SPAN=20 class=3D039060612-11102000> ;</SPAN><BR></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" = size=3D2> </DIV></FONT>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console"=20

size=3D2>TO_DATE('25-DEC-00','DD-MON-YY')-SYSDATE<BR>-------------------=
---------------------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=

;           &nbsp= ;          =20 74.331516<BR></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D039060612-11102000>HTH,</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D039060612-11102000>Rajesh</SPAN></FONT></DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">   <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Mark = Leith<BR><B>Sent:</B>=20
  Wednesday, October 11, 2000 4:00 PM<BR><B>To:</B> Multiple recipients = of list=20
  ORACLE-L<BR><B>Subject:</B> How many days until=20 Christmas?<BR><BR></DIV></FONT>

  <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></= DIV>
  <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> Received on Wed Oct 11 2000 - 07:07:40 CDT