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: 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.

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

<!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>&nbsp;&nbsp;&nbsp; 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>&nbsp;</DIV> <DIV><BR><FONT color=3D#0000ff face=3D"Lucida Console" = size=3D2>&nbsp;&nbsp; SQL&gt;=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>&nbsp;</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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&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>&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></= DIV>
  <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> Received on Wed Oct 11 2000 - 07:07:40 CDT

Original text of this message

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