Can someone show me how I can output hrs:mins:secs in mySQL SELECT statement below?

[dseals22]

Here is what I have so far when use the DATE_ADD function in MySQL Workbench 6.3, but I have been struggling to output the hrs:mins:secs (you don't see the code for that output because I didn't write it here). I know that I can use INTERVAL HOUR_SECOND to display hrs:mins:secs but I don't understand how it works.

SELECT DATE_ADD('2017-01-26', INTERVAL 31 DAY) AS '31 Days';

I know this SELECT statement above will output 31 days from the specified date indicated above, but what do I need to do to output the hrs:mins:secs along with the 31 days from the date in the SELECT statement?

Below is the output of how I would like it to be, but the hours:minutes:s ecs must be time corresponding to 31 days after the day indicated above in my SELECT statement.

[RonB]

Did you read the documentation for the date_add function? It has an example doing exactly what you want.

https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-add

Here's another example.

http://www.w3schools.com/sql/func_date_add.asp