On 3/18/08, 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
> 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
select strftime('%M', datetime(startTime *60, 'unixepoch','-8 hours'));
you do know that all the datetime options are documented at
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
> 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
>
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
