13 thoughts on “Are you really 18 years old today?

  1. Claudia Zeiler

    Hi Laurent,
    The person born Feb 29, 1992 acquires the day the the one born Feb 28, 1990 lost.

    1* select add_months(date ‘1992-02-29’,18*12) from dual
    SQL> /

    ADD_MONTH
    ———
    28-FEB-10

    By the way, do you know “The Pirates of Penzance”? The whole plot turns around the hero who was indentured to pirates until his 21st birthday. BUT he was born Feb 29. No one ever claimed that Gilbert and Sullivan make sense. :-))
    -Claudia

  2. Laurent Schneider Post author

    Hi Claudia,
    No, I did not know the Pirates of Penzance.
    I have an uncle who is celebrating his 18th birthday tomorrow… since his father reached its 101st I would not be surprised he will reach 21st.
    🙂
    Laurent

  3. radino

    nothing unexpected..

    doc:
    If date is the last day of the month or if the resulting month has fewer days than the day component of date, then the result is the last day of the resulting month.

  4. Anonymous

    If I was born Feb 28, 1990. Today is my birth day for 18 years old.

    ADD_MONTH
    ———
    27-FEB-08

    SQL> select add_months(date ‘1990-02-28’,18*12) from dual;

    ADD_MONTH
    ———
    29-FEB-08

  5. HunterX

    OK!
    I can watch adult movie or drink Gin-tonic.

    create function add_mon (date1 IN DATE,add_mon IN NUMBER) return DATE IS loc_date2 date;

    BEGIN
    loc_date2:= ADD_MONTHS(date1-1,add_mon);

    IF LAST_DAY(date1) = date1
    THEN
    IF LAST_DAY(loc_date2)=loc_date2
    THEN
    RETURN loc_date2;
    ELSE
    RETURN loc_date2 +1;
    END IF;
    ELSE
    RETURN ADD_MONTHS(date1,add_mon);
    END IF;

    END;
    /

    SQL> l
    1 declare
    2 a date;
    3 begin
    4 a := add_mon (to_date(‘1990-02-28′,’YYYY-MM-DD’),18*12);
    5 dbms_output.put_line(a);
    6* end;
    SQL> /
    28-FEB-08

  6. scott burnworth

    common law provides that a person becomes 18 at 12:01 am on the day before the 18th birthday.

  7. erica hutchinson

    hi, i was born feb. 29 1992 and i’ll be turning 18 soon but the problem is when? will it be feb.28th because its the last day of that month or will it be march 1st? i’ve always held it on the 28th every common year beacuse i have twin brothers born 2 years before me on march 7th, so i can have my own month. i need to know governmently wise when will i be 18 but i just cant find my answer!!!!

  8. Laurent Schneider

    it depends on the country. In France, you would be able to vote or get elected on Feb 28.

    Did you intend to drink alcohol on that day? Get married? Commit crime? (or all three)

    Please try to look in your government websites

Comments are closed.