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: alex <alex.apostolopoulos_at_mindmatics.de>
Date: Wed, 11 Oct 2000 13:55:41 +0200
Message-Id: <10646.118957@fatcity.com>


Hi

select round(to_date('24-DEC-00', 'DD-MON-YY')-SYSDATE) from dual;

merry xmas

>
> 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
>
>


Content-Type: text/html; name="unnamed"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------
Received on Wed Oct 11 2000 - 06:55:41 CDT

Original text of this message

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