Message-Id: <10646.118951@fatcity.com> From: "Toepke, Kevin M" Date: Wed, 11 Oct 2000 07:35:00 -0400 Subject: RE: How many days until Christmas? 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@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