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
3374 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 edit a trigger in mysql?

842

What are the indexes in mysql?

941

How to drop an existing index in mysql?

1027

Is blocked because of many connection errors mysql?

789

How we can get distinct columns values in mysql?

1012

What is a csv table?

944

How do I clear the screen in mysql?

947

What is mysql installer?

946

Is oracle better than mysql?

827

Can mysql store files?

865

What is row locking in mysql?

909

What is mysqladmin flush hosts?

907

What is max_used_connections in mysql?

897

How to list or view all databases from the mysql server.

874

How do I start and stop mysql on windows?

936