"Joanne Pham" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> 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.
>
> I would like to return only the number of minutes as below
In place of datetime, use strftime('%M', ...)
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
