>Sir, I am using SQL SERVER 2008.
>
>Suppose I have following data
>
>

>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
>For second record
>
>

>AA={^2019-02-08 01:25:29 AM}-{^2019-02-08 01:25:28 AM}   && 1 Second
>

use (dbf("junk")) in 0 again alias secondcursor
set relation to recno()-1 into secondcursor
select junk
replace nSeconds with date-secondcursor.date for recno()>1
set relation to
use in select("secondcursor")