RE: subtract dates
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 May 2004 10:12:18 +0100
In a production system if you are subtracting 2 dates and multiplying by one of
24,1440 or 86400 to obtain differences in the relevant units, it may well be
worth noting that the days between date 1 and date 2 may not necessarily have
24 hours in them, and therefore the calculation may be incorrect.
<OT Rant>
This is about the 3rd time I have tried to send this message to the list, I get
no delivery failure but my message does not appear. On the other hand messages
I have sent in the mean time are appearing. Is Mladen occasionally connecting
me to dev/null for fun, am I incompetent (actually don't answer that) or is
this perhaps happening to others? Natuarlly my mail administrators say that
there is nothing wrong (and point me to the lack of error messages as 'proof').
</Rant>
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
