Use the Oracle trunc function on the dates. Trunc() removes the time portion so both dates are at midnight.
trunc(date1) - trunc(date2) Dan > -----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... > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists