Message-Id: <10646.118948@fatcity.com> From: "Mark Leith" Date: Wed, 11 Oct 2000 11:55:16 +0100 Subject: How many days until Christmas? This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C0337A.1EE38DB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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@cool-tools.co.uk ------=_NextPart_000_001D_01C0337A.1EE38DB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi=20 Guy's

I've = been asked a=20 question, but haven't the time to check it, so I'm sorry if its simple. = Is there=20 a way of finding the difference in days between sysdate (today) and a = point in=20 time in the future (Christmas) through Oracle?

Don't = ask me why,=20 mine is just to do and die..

Thanks

Mark

Mark Leith

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Cool Tools UK = Ltd

+44 1905 330 = 281

mark@cool-tools.co.uk