|
-
It's a bit confusing: although the dates are stored in that special 7-byte format, date arithmetic behaves as if the date/time combination is number (Julian date including fractions of day) - so you can:
Select sysdate - trunc(sysdate) from dual; --gives the time as a fraction of a day since midnight.
Select sysdate + 1 from dual; --tells you what tommorow is.
(BTW: since version 8 or 8i, the upper limit is 31-DEC-9999 AD)
Last edited by DaPi; 02-06-2004 at 07:53 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote