On Tuesday, January 28, 2003, at 03:04 PM, Joshua Lavin wrote:
So, I guess the only way to make it work would be manually, dividing by 60, etc.
For anyone who cares, I actually made it work. Not too hard; just convert the time to seconds, sum the rows, and convert back to time:
[query sql="select sec_to_time(sum(time_to_sec(length))) from music where sku = [item-code]" table=music type=list]
[list]<p>Total playing time (HH:MM:SS): [sql-pos 0]</p>[/list] [/query] Josh _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.