----- Original Message ----
From: Joanne Pham <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <[email protected]>
Sent: Tuesday, March 18, 2008 4:40:54 PM
Subject: How to get the minutes number only
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.
Never miss a thing. Make Yahoo your homepage.
____________________________________________________________________________________
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
