By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,337 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,337 IT Pros & Developers. It's quick & easy.

How can I get the DATE_ADD to output the hrs:min:secs after it calculates 31 days?

P: 74
How can I get the DATE_ADD to output the hrs:min:secs after it outputs 31 days from the specified date in my SELECT code below?

SELECT
DATE_ADD('2017-01-26',
INTERVAL 1 MONTH) AS '31 Days';
Jan 27 '17 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.