lets say I have certain dates (x) and (y) now I do a ((x) - (y)) in oracle and I get a number like 18.12 or 18.82
I was doing a round of the result above which yielded me 18 or 19 based on the percentile. While I was expecting 19 always, the ceil function helped me to achieve that. Hope that helps clarify the question... More of a rounding issue. -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:10 AM To: CF-Talk Subject: Re: days between function in Oracle... ceiling() will round up What's your question ...days beween dates or rounding? On Tue, 20 Aug 2002, Alex Ninan wrote: > Hi, > > Does anyone know of a function I can use to get the number of days between 2 > dates in Oracle. My basic problem is I can get the dates but on using the > round function it's screws up... > > e.g > round(18.12) = 18 days > round(18.82) = 19 days > > What I want is a function which does > > function(18.12) = 19 days > function(18.82) = 19 days > > Thanks > > Alex > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
