RE: How many days until Christmas?

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Wed, 11 Oct 2000 04:34:15 -0700
Message-Id: <10646.118949@fatcity.com>

Try

SELECT TRUNC(TO_DATE('25-DEC-2000','DD-MON-YYYY')) - TRUNC(SYSDATE) FROM dual;

BTW 75 days
Rick

> -----Original Message-----
> From: Mark Leith [SMTP: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
> mark_at_cool-tools.co.uk <mailto:mark_at_cool-tools.co.uk>
Received on Wed Oct 11 2000 - 06:34:15 CDT