Are you really 18 years old today?

18 is a nice age here. You can vote, you can watch movie or drink Gin-tonic. You also get married and go to jail !

Are you really 18 today?

select add_months(date '1990-02-28',18*12) from dual;
29.02.2008 00:00:00

come back tomorrow 😈

or check an old post of mine How old are you 😀

Published by

Laurent Schneider

Oracle Certified Master

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

  1. 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> /


    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. :-))

  2. 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.

  3. nothing unexpected..

    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. If I was born Feb 28, 1990. Today is my birth day for 18 years old.


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


  5. 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;

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

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


    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> /

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

  7. 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. 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

Leave a Reply