Message-Id: <10646.118960@fatcity.com> From: Rajesh Dayal Date: Wed, 11 Oct 2000 16:07:40 +0400 Subject: RE: How many days until Christmas? 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@fatcity.com [mailto:root@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@cool-tools.co.uk =A0 ------ =_NextPart_001_01C0337B.DCCDD0E6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
    It looks=20 simple.....
 

   SQL>=20 select to_date('25-Dec-00','dd-mon-yy') - sysdate from dual ;
 
TO_DATE('25-DEC-00','DD-MON-YY')-SYSDATE
-------------------= ---------------------
        = ;            = ;          =20 74.331516
HTH,
Rajesh
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Mark = Leith
Sent:=20 Wednesday, October 11, 2000 4:00 PM
To: Multiple recipients = of list=20 ORACLE-L
Subject: How many days until=20 Christmas?

Hi=20 Guy's
 
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?
 
Don't ask me why,=20 mine is just to do and die..
 
Thanks
 
Mark
 
Mark Leith
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Cool Tools UK=20 Ltd
+44 1905 330 = 281
mark@cool-tools.co.uk