top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can I Know the number of days between two given dates using MySQL?

+1 vote
361 views
posted May 30, 2014 by Amritpal Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The following function can be used to calculate number of days between two dates.
SELECT DATEDIFF("2014-06-02","2014-01-01");

answer Jun 2, 2014 by Karamjeet Singh
Similar Questions
0 votes

How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.

+1 vote

So, I've been tearing apart mysql-connector-odbc-5.1.11-1.fc18.x86_64 And I've tracked down some horrible breakage there that needs to be fixed upstream.

Given the state of mysql in the distro, and the pending move to mariadb, I'm wondering where the best place to report this bug would be. I find nothing but Oracle's bureaucratease, when I try to dig around mysql.com.

+5 votes

How can I insert the content of excel file into MySQL Table, any pointer?

+2 votes

I have moderate level PHP programming skills. I am also interested in merging those skills inside of the WordPress app. With their advanced responsive design themes and many other functions it seems like a good idea. I have tried loading some PHP plug-ins in WP – but I don't seem to get them to do more than basics.

Can anybody help me on how I can get started working with PHP/MySQL inside of the WordPress app?

...