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,
JP
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
