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
Never miss a thing. Make Yahoo your homepage.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
