CODEWITHSUNDEEP
mysql
user4045747
user4045747

Reputation:

calculate time diffrence in mysql by seconds

I have two dates I want to calculate the diffrence between them to copare it with int

as P_date1 datetime, P_date2 datetime

int a=P_date1 - P_date2;

Upvotes: 1

Views: 33

Answers (2)

Gervs
Gervs

Reputation: 1397

Use TIMESTAMPDIFF:

SELECT TIMESTAMPDIFF(SECOND, P_date1, P_date2) AS diff FROM .....

This function can be used with different time units

Upvotes: 1

nesreen
nesreen

Reputation: 201

select a= TIMESTAMPDIFF(MINUTE,P_date1 ,P_date2) .. to minutes


select a= TIMESTAMPDIFF(SECOND,P_date1 ,P_date2)... to seconds

Upvotes: 2

Related Questions