version 4.0.2 or above, then try using the CAST() or CONVERT() function
on the _expression_ that's failing.
Usage I think you're looking for is:
SELECT TL.T_id, CAST(MAX(dPosted) AS CHAR) as LastDaySeen
You can find the MySQL manual page here:
http://www.mysql.com/doc/en/Cast_Functions.html
--
Oliver Tupman
Key Systems Geotechnical
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
