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
______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
