Calculate difference between two dates in MySQL.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 521
Calculating difference between two dates in MySQL is really easy.Here’s how we can do it.
Let’s say dt1 and dt2 are the 2 columns in table table_name.Just replace dt1,dt2 and table_name in the queries below with our values.

Difference between two dates stored as variables
SELECT UNIX_TIMESTAMP(dt2) - UNIX_TIMESTAMP(dt1) from table_name;

Difference between two dates stored as variables
SET @dt1='2013-11-09 00:00:00';
SET @dt2='2012-10-07 00:00:00';
SELECT UNIX_TIMESTAMP(@dt2) - UNIX_TIMESTAMP(@dt1);

Comments or Responses

Login to post response