calculate timediff in sec between two rows-CodePudding

Home > Back-end > calculate timediff in sec between two rows

calculate timediff in sec between two rows

Time：09-26

MariaDB 10.3.36

i need to calculate the timediff in sec between the date row and
create a new column like diff_sec

CodePudding user response：

SELECT id,date,section, TIMESTAMPDIFF(SECOND,date,
                  lag(date, 1) OVER (ORDER BY date)) as diff_sec 
FROM garagedoor;

This works for me. Thx

CodePudding user response：

Try this code:

(MySQL Code):

SELECT id,date,section,
TIMESTAMPDIFF(SECOND,date,
LAG(date, 1) OVER (ORDER BY date)) as diff_sec 
FROM difference;

If we run the code,