Here's what Google tells me regarding days between "now()" and a database column value.
select extract(day from (sysdate - dte_2dlcl)) I have no idea if that's correct and can't test. I think it's a step in the right direction. Here's the reference: http://stackoverflow.com/questions/1646001/how-can-i-get-the-number-of-days-between-2-dates-in-oracle-11g On Fri, Jan 14, 2011 at 8:15 AM, Michael Grant <mgr...@modus.bz> wrote: > Wait. I don't think Oracle 11g even has a dateDiff function. Does it? > > > > On Fri, Jan 14, 2011 at 7:53 AM, Jay Birdsell > <john_birds...@hotmail.com>wrote: > >> >> >I suspect dte_2dlcl is the name of a date/time column in his database. >> >Though it shouldn't be surrounded in single quotes if that's the case. >> > >> >On Thu, Jan 13, 2011 at 3:23 PM, Russ Michaels <r...@michaels.me.uk> >> wrote: >> > >> >> >> >> Thank you everyone for your input. I'm using an oracle 11g db, dte_2dlcl >> is a date field in the table I am working with. I need to determine the >> interval between two dates and need to display any records with a date >> interval in the range of 0 - 8, >> >> I have tried both database dateDiff() and the CF version. obviously, i am >> getting confused with what should be surrounded by quotes. I'll try the >> suggestions you all have posted and get back to you. >> >> thanks again. >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
