for getting date difference you can use it....... select to

at first i'm using
datediff('d', a.due_date, current_date);
but it takes too long to get the result
but how can i subtract the current_date - a.due_date
and still get the same result like when i use datediff?
thank you

Question Posted / sudhanshu_kmr

1 Answers
3516 Views
I also Faced
E-Mail Answers

Answer Posted / sudhanshu_kmr

for getting date difference you can use it.......

select to_days(now())- to_days(date);

for example-

SELECT TO_DAYS(NOW())- TO_DAYS('2010-12-01');

TO_DAYS(DATE) command return a number which is total no. of
days between '0000-01-01' and the given date.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I rename a table in mysql?

975

Which is faster innodb or myisam?

1043

What is horizontally scalable?

982

How do I completely remove mysql from windows?

971

What is the difference between database and table?

1003

How to get a version of mysql?

1044

How can you retrieve a portion of any column value by using a select query?

917

What is the difference between truncate and delete in mysql?

1136

What are the different mysql database engines?

1163

How to check if value already exists in mysql database in php?

888

How do I setup a mysql database?

978

How do you create a schema?

953

What is a csv table?

1001

Explain the different types of mysql joins.

925

How do I create a schema in mysql?

872