Re: [sqlite] How to get the minutes number only

Joanne Pham wrote: > > > > > I would like to return only the number of minutes as below > The strftime function is your friend: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions HTH, Gerry ___ sqlite-users mailing list

Re: [sqlite] How to get the minutes number only

Joanne Pham <[EMAIL PROTECTED]> wrote: > 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

Re: [sqlite] How to get the minutes number only

- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database 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,

[sqlite] 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

[sqlite] 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