This is the simplest format of finding datetime difference in Minutes
select TIMESTAMPDIFF(
HOUR, '2013-10-19 10:42:53', '2013-10-19 10:43:53' ) AS minutes from table name
If u want to give the column names to find datetime diference.....
select TIMESTAMPDIFF(
HOUR, colname1, colname2 ) AS minutes from table name
select TIMESTAMPDIFF(
HOUR, '2013-10-19 10:42:53', '2013-10-19 10:43:53' ) AS minutes from table name
If u want to give the column names to find datetime diference.....
select TIMESTAMPDIFF(
HOUR, colname1, colname2 ) AS minutes from table name
No comments:
Post a Comment