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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]