Question 113500 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – calculate timediff in sec between two rows

MariaDB 10.3.36

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

enter image description here

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
    SELECT id,date,section, TIMESTAMPDIFF(SECOND,date,
                  lag(date, 1) OVER (ORDER BY date)) as diff_sec 
FROM garagedoor;

    This works for me. Thx


  2. 0

    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,

    Updated Solution

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search