Result with number of days

Question

I have a DATETIME column in my table and I would like to know the number of days between the DATETIME value and now.

The query must be something like this:

SELECT *, DATESUBWHATEVER(datetimefield) AS days FROM table

Link to Manual with lots of date functions: http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html — xQbert, Nov 12 '15 at 15:28

score 1 · Answer 1 · answered Nov 12 '15 at 15:42

1

SELECT TIMESTAMPDIFF(DAY, datetimefield, NOW()) AS days from table;

answered Nov 12 '15 at 15:42

Fabian Winkler

score 0 · Answer 2 · answered Nov 12 '15 at 15:46

0

You can use the DATEDIFF() function

SELECT *, DATEDIFF(DateTimeField,NOW()) FROM TABLE

DATEDIFF parameters explained:

DATEDIFF(date1,date2)

answered Nov 12 '15 at 15:46

Curtis Elliott

2 Answers2