Hi All
I ran the following statement:
select datetime(startTime *60, 'unixepoch','-8 hours') , bytesIn from
wanPerfTable where appId = 30 and remoteWXId = 200;
and below is my output.
2007-12-03 11:00:00 20
2007-12-03 11:01:00 5
2007-12-03 11:02:00 100
2007-12-03 11:03:00 50
2007-12-03 11:58:00 50
I would like to return only the number of minutes as below
0 20
1 5
2 100
3 50
58 25
So would you please help
Thanks,
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
