Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: mcohen@attbi.com (Mike Cohen) Newsgroups: comp.databases.oracle.misc Subject: Re: finding # of days between two dates? Date: 11 Nov 2002 13:51:40 -0800 Organization: http://groups.google.com/ Lines: 34 Message-ID: <9a742dd3.0211111351.3263dc3a@posting.google.com> References: <9a742dd3.0211081301.63e8791@posting.google.com> NNTP-Posting-Host: 12.46.129.130 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037051500 27118 127.0.0.1 (11 Nov 2002 21:51:40 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Nov 2002 21:51:40 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.misc:89226 X-Received-Date: Mon, 11 Nov 2002 14:51:24 MST (news.easynews.com) Hi, The Original Poster here. To those of you who offered up answers to my questions. Thank you very much. For those of you who had an issue with me actually asking a question to the group: I've only been prgramming for a few years now, but one of the first things I learned is that there are people out there such as yourselves who don't have much except for your vast knowledge and possible guru-shipness (is that even a word) of a particular subject. Some of you choose to use this as your way of controlling your little world and maybe even feeling a little powerful. To that I say all the more power to you, but c'mon, get a life fellas. Mike "Bob Redding" wrote in message news:... > If the dates are stored in Oracle date fields, simply subtract the oldest > from the more current date. Otherwise, use the to_date function to subtract > the dates. > > "Mike Cohen" wrote in message > news:9a742dd3.0211081301.63e8791@posting.google.com... > > Hi, > > > > How would I find the number of days between two Oracle dates? Is > > there a simple function I can utilize? > > > > Thanks!! > > > > Mike