Using ROUND() on the dates seems to work. Try something like this: ROUND(date2) - ROUND(date1)
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com > -----Original Message----- > From: Alex Ninan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 20, 2002 11:32 AM > To: CF-Talk > 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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
