Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle dates calculations

Re: oracle dates calculations

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.com>
Date: Fri, 27 Jun 2003 14:33:03 GMT
Message-ID: <zAYKa.33045$Ab2.58464@sccrnsc01> 





    
  
  1.   dates are not strings.  dates are displayed and that is what you are
seeing.  Subtract the date of birth and today (sysdate) and if the
difference is >= 18 * 365 then the individual is 18.
Jim
"jim agans" <jwagans_at_yahoo.com> wrote in message
news:82659da6.0306270629.68eee0cd_at_posting.google.com...

    
> I have a date of birth.....'MMDDYYYY' What I need to do is find out if
    
> the individual is 18 years old on this date.
    
>    How can I do it ...any help someone?
    
>
    
>    thanks
    
>    jim
    



Received on Fri Jun 27 2003 - 09:33:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US