Mister Jack wrote:
Hi,
i'm using the 4.1.10 version of mysql. If I do :
select max(timestamp + 0 ) as timestamp from news; +----------------+ | timestamp | +----------------+ | 20050314194920 | +----------------+
so i got the full timestamp(14), but if I do : select max(timestamp) + 0 as timestamp from news; +-----------+ | timestamp | +-----------+ | 2005 | +-----------+
Did i miss something in the documentation ? or is it normal ? thanks
What does select max(timestamp) as timestamp from news; return? What would you get if that string was converted to a number?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
