1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

how to extract difference between timestamps

Discussion in 'Programming/Internet' started by cerr, Oct 8, 2018.

  1. cerr

    cerr Guest

    SQL greenhorn alarm:
    I have a table with timestamp information (44 rows) and I now would like to calculate and extract the delta between any two consecutive rows. How can I do this? I select my data with a query like:

    SELECT * from "table" where "RecognitionTimestamp" >= '2018-10-03 00:00:00' and "RecognitionTimestamp" <= '2018-10-04 9:00:00'

    I'm using pgAdmin4 to submit the query and look at the data.

    Login To add answer/comment

Share This Page