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: Toepke, Kevin M <ktoepke_at_cms.cendant.com>
Date: Wed, 11 Oct 2000 07:35:00 -0400
Message-Id: <10646.118951@fatcity.com>


SQL> select TO_DATE('25-dec-2000') - sysdate   2 FROM DUAL; TO_DATE('25-DEC-2000')-SYSDATE


                    74.6803009


-----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 Received on Wed Oct 11 2000 - 06:35:00 CDT

Original text of this message

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