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:RE: How many days until Christmas?

# Re:RE: How many days until Christmas?

From: <dgoulet_at_vicr.com>
Date: Wed, 11 Oct 2000 09:22:55 -0400
Message-Id: <10646.118967@fatcity.com>

up with a dozen or more ways to get the answer, all of which are correct = (in one
form or another).

Dick Goulet

```____________________Reply Separator____________________
```
Subject: RE: How many days until Christmas? Author: Rajesh Dayal <Rajesh_at_ohitelecom.com> Date: 10/11/00 5:06 AM

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-----
Sent: Wednesday, October 11, 2000 4:00 PM To: Multiple recipients of list ORACLE-L

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

=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">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-asci=
```
i">
```<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN =

```

class=3D039060612-11102000>Hi,</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN =

class=3D039060612-11102000>&nbsp;&nbsp;&nbsp; It looks =

simple.....</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN =

class=3D039060612-11102000></SPAN></FONT>&nbsp;</DIV> <DIV><BR><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2>&nbsp;&nb= sp; SQL&gt; =

select to_date('25-Dec-00','dd-mon-yy') - sysdate from dual<SPAN =

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" =

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

-----------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

74.331516<BR></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN =

class=3D039060612-11102000>HTH,</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN =

class=3D039060612-11102000>Rajesh</SPAN></FONT></DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">   <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT face=3DT= ahoma =

size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com =

[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Mark Leith<BR><B>Sent:</B>=  =

Wednesday, October 11, 2000 4:00 PM<BR><B>To:</B> Multiple recipients o= f list =

ORACLE-L<BR><B>Subject:</B> How many days until =

Christmas?<BR><BR></DIV></FONT>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-10102000>Hi =

Guy's</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-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) a= nd a =

point in time in the future (Christmas) through Oracle?</SPAN></FONT></= DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=3DArial size=3D2><SPAN class=3D344432115-10102000>Don't=  ask me why, =

mine is just to do and die.. </SPAN></FONT></DIV>   <DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000>Thanks</SPAN></FONT></DIV>   <DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT face=3DArial size=3D2><SPAN =

class=3D344432115-10102000>Mark</SPAN></FONT></DIV>   <DIV><FONT face=3DArial size=3D2><SPAN =

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 =

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 =

```

href=3D"mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></FONT><= Received on Wed Oct 11 2000 - 08:22:55 CDT

Original text of this message

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