RE: How many days until Christmas?

From: <Jorma.Vuorio_at_nokia.com>
Date: Wed, 11 Oct 2000 14:56:26 +0300
Message-Id: <10646.118956@fatcity.com>

Something like this:  

select trunc(to_date('24.12.2000','dd.mm.yyyy') -sysdate) from dual;

-----Original Message-----
From: EXT Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: 11 October, 2000 15:00
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> Received on Wed Oct 11 2000 - 06:56:26 CDT