Use the Ceiling or Ceil function (can't remember exactly which one it is) Cheers,
Sam ----- Original Message ----- From: "Alex Ninan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 11:32 AM Subject: days between function in Oracle... > 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 > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists