Code:
--------------------
SELECT LEFT(title, 255),
playcount,
FROM_UNIXTIME(lastplayed)
FROM tracks WHERE FROM_UNIXTIME(lastplayed) > '2005-11-01'
--------------------
--
Jim
------------------------------------------------------------------------
Jim's Profile: http://forums.slimdevices.com/member.php?userid=213
View this thread: http://forums.slimdevices.com/showthread.php?t=18520
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
