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: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 11 Oct 2000 08:01:01 -0400
Message-Id: <10646.118954@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_01C0337A.ECD3BCE0
Content-Type: text/plain;

        charset="iso-8859-1"

Isn't this it?  

  1* select trunc(to_date('25dec2000','ddmonyyyy') - sysdate) days from dual SQL> /         DAYS


        74  

SQL>     Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174 
F: 954.484.2933 
C: 954.658.5849 

http://www.qode.com <http://www.qode.com/>

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Wednesday, October 11, 2000 8:00 AM To: Multiple recipients of list ORACLE-L Subject: How many days until Christmas?

Hi Guy's  

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?  

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

Thanks  

Mark  

Mark Leith



Cool Tools UK Ltd
+44 1905 330 281
mark_at_cool-tools.co.uk <mailto:mark_at_cool-tools.co.uk>  

------_=_NextPart_001_01C0337A.ECD3BCE0
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=059150012-11102000>Isn't
this it?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=059150012-11102000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=059150012-11102000>&nbsp;
1* select trunc(to_date('25dec2000','ddmonyyyy') - sysdate) days from dual<BR>SQL&gt; /</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=059150012-11102000>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DAYS<BR>----------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 74</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=059150012-11102000>SQL&gt; </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=059150012-11102000></SPAN></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<P><B><FONT face=Arial size=1>Lisa Rutland Koivu</FONT></B> <BR><FONT face=Arial
size=1>Oracle Database Administrator</FONT> <BR><FONT face=Arial size=1>Qode.com</FONT> <BR><FONT face=Arial size=1>4850 North State Road 7</FONT> <BR><FONT face=Arial size=1>Suite G104</FONT> <BR><FONT face=Arial size=1>Fort Lauderdale, FL&nbsp; 33319</FONT> </P>
<P><FONT face=Arial size=1>V: 954.484.3191, x174</FONT> <BR><FONT face=Arial
size=1>F: 954.484.2933 </FONT><BR><FONT face=Arial size=1>C: 954.658.5849</FONT>
<BR><FONT face=Arial size=1><A href="http://www.qode.com/"
target=_blank>http://www.qode.com</A></FONT> </P>
<P><I><FONT color=#000000 face=Arial size=1>"The information contained herein
does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."</FONT></I></P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Mark Leith   [mailto:mark_at_cool-tools.co.uk]<BR><B>Sent:</B> Wednesday, October 11, 2000   8:00 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>   How many days until Christmas?<BR><BR></DIV></FONT>

  <DIV><FONT face=Arial size=2><SPAN class=344432115-10102000>Hi 
  Guy's</SPAN></FONT></DIV>
  <DIV><FONT face=Arial size=2><SPAN 

  class=344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=Arial size=2><SPAN class=344432115-10102000>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?</SPAN></FONT></DIV>   <DIV><FONT face=Arial size=2><SPAN
  class=344432115-10102000></SPAN></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2><SPAN class=344432115-10102000>Don't ask me why, 
  mine is just to do and die.. </SPAN></FONT></DIV>
  <DIV><FONT face=Arial size=2><SPAN 

  class=344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=Arial size=2><SPAN
  class=344432115-10102000>Thanks</SPAN></FONT></DIV>   <DIV><FONT face=Arial size=2><SPAN
  class=344432115-10102000></SPAN></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2><SPAN 
  class=344432115-10102000>Mark</SPAN></FONT></DIV>
  <DIV><FONT face=Arial size=2><SPAN 

  class=344432115-10102000></SPAN></FONT>&nbsp;</DIV>
  <DIV><FONT color=#0080ff size=2><EM>Mark Leith</EM></FONT></DIV>
  <DIV><FONT color=#ff0000 face=Arial size=2>=================</FONT></DIV>
  <DIV><FONT color=#0080ff size=2><STRONG>Cool Tools UK 
Ltd</STRONG></FONT></DIV>
  <DIV><FONT color=#0080ff face=Arial size=2>+44 1905 330 281</FONT></DIV>   <DIV><FONT face=Arial size=2><A
  href="mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></FONT></DIV>   <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> Received on Wed Oct 11 2000 - 07:01:01 CDT

Original text of this message

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