Results 1 to 3 of 3

Thread: Dob

  1. #1
    Join Date
    Feb 2009
    Posts
    48

    Post Unanswered: Dob

    how to find age like this '19/feb/10' in 9i
    and how we can the objects in a specific tablespace.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Date arithmetics' results in number of days, so - if you subtract your date of birth from today's date, you'll get number of days. Then convert it to more suitable format, if you wish.

    For the second question, check the documentation I provided in your previous message.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select floor(months_between(trunc(sysdate),to_date('19/feb/1910','dd/mon/yyyy'))/12) age from dual;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •