How do you get days when subtracting a date column from the current date in mysl

Hi

How do you getthe days value when you subtract a date from the curdate()?
SELECT
(curdate() - tracker.PP_dateDue) AS 'Days_Late'
FROM
tracker
matthewdacruzAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Goodangel MatopeConnect With a Mentor Software ArchitectCommented:
USE DATEDIFF('current_date', 'old_date')

AS shown below:

SELECT
DATEDIFF(curdate() , tracker.PP_dateDue) AS 'Days_Late'
FROM
tracker
0
 
matthewdacruzAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.