CREATE CURSOR junk(date t,nSeconds n(4)) INSERT INTO junk values({^2019-02-08 01:25:28 AM}, 0) INSERT INTO junk values({^2019-02-08 01:25:29 AM}, 0) INSERT INTO junk values({^2019-02-08 01:25:55 AM}, 0) INSERT INTO junk values({^2019-02-09 02:28:29 AM}, 0) INSERT INTO junk values({^2019-02-09 02:50:18 AM}, 0) INSERT INTO junk values({^2019-02-09 08:59:17 PM}, 0) INSERT INTO junk values({^2019-02-09 10:25:39 PM}, 0) INSERT INTO junk values({^2019-02-12 03:05:19 AM}, 0)I want to fill nSeconds column like this
AA={^2019-02-08 01:25:29 AM}-{^2019-02-08 01:25:28 AM} && 1 Second
Second() difference with Previous record.