Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.


    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

Age calculate

@pearljy22

New Coder
Please help me. I have a problem, I can't get the day/s old.
[CODE lang="sql" title="EXAMPLE OUTPUT:"]2 MONTHS AND 14 DAYS


DECLARE n_yr INT(11);

DECLARE n_mon INT(4);

DECLARE n_day INT(4);



SELECT TIMESTAMPDIFF( YEAR, prev_dte, cur_dte ) INTO n_yr;

SELECT TIMESTAMPDIFF( MONTH, prev_dte, cur_dte ) % 12 INTO n_mon;

SELECT FLOOR( TIMESTAMPDIFF( DAY, prev_dte, cur_dte ) %30.5375 ) INTO n_day;



IF n_yr THEN

RETURN CONCAT(n_yr, IF(n_yr > 1, ' years', ' year'));

ELSEIF n_mon THEN

RETURN CONCAT(n_mon, IF(n_mon > 1, ' months ', ' month '), n_day, IF(n_day > 1, ' days', ' day'));

ELSE

RETURN CONCAT(n_day, IF(n_day > 1, ' days', ' day'));

END IF;[/CODE]
 
Last edited by a moderator:

New Threads

Buy us a coffee!

Back
Top Bottom