RE: How many days until Christmas?

Hi all,

Thanks for the quick replies.. This works just great with Lisa's option.

And a merry xmas to all :) Bahhhhh humbug!

Cheers

Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of alex Sent: 11 October 2000 14:06
To: Multiple recipients of list ORACLE-L Subject: Re: How many days until Christmas?

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: alex
  INET: alex.apostolopoulos_at_mindmatics.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).