How do i Get the difference between the current date and a Date in the database and Display it in the table

Question

$query= "SELECT * FROM debtors WHERE DATE_FORMAT(DueDate,'%Y-%m-%d') < CURDATE()";

This is the sql query I use to fetch the dates which have passed today's date.

SQL is a language, specified by ISO/ANSI. Perhaps you mean MS SQL Server? — jarlh, Sep 05 '19 at 08:56
actually this is for my college project i am doing it in phpmyadmin — Oliver, Sep 05 '19 at 08:57
Then FYI : you are currently using MySQL or MariaDB since CURDATE only exist on those AFAIK — Frankich, Sep 05 '19 at 08:58

Divyesh patel · Answer 1 · 2019-09-05T09:44:11.383

2

$query=SELECT *,DATEDIFF(mm,YOUR_DATE,CURRENT_TIMESTAMP) as diffInMonth FROM debator;

May be helpful to you.It works in MS SQL 2012 for me. DATEDIFF(interval,start_date,end_date);

edited Sep 05 '19 at 09:44

answered Sep 05 '19 at 09:29

Divyesh patel

$query= "SELECT *, datediff(curdate(), DueDate) as dd FROM debtors WHERE DATE_FORMAT(DueDate,'%Y-%m-%d') < CURDATE()"; i tried this and its working thnks to @metal – Oliver Sep 05 '19 at 13:37

score 1 · Accepted Answer · answered Sep 05 '19 at 09:01

1

Here's how to get the difference, based on your query. using datediff

$query= "SELECT *, datediff(curdate(), DueDate) FROM debtors WHERE DATE_FORMAT(DueDate,'%Y-%m-%d') < CURDATE()";

answered Sep 05 '19 at 09:01

Ed Bangga

score 1 · Answer 3 · answered Sep 05 '19 at 09:16

1

Please try with this one:

$query= "SELECT *, DATEDIFF(CURDATE(), STR_TO_DATE(DueDate, '%Y-%m-%d')) AS days FROM debtors WHERE DATE_FORMAT(DueDate,'%Y-%m-%d') < CURDATE()";

answered Sep 05 '19 at 09:16

Kamal Sanghavi

Thanks for the answer bt i tried @metal answer and it working fine – Oliver Sep 05 '19 at 13:36

3 Answers3