RE: subtract dates

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 13 May 2004 10:12:18 +0100
Message-ID: <CFECD6EA683C524BB5FD22C0F1F34ACB01936CAE@bristol43.audit-commission.gov.uk>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu May 13 2004 - 04:09:48 CDT