hiya, using mysql under zope i want to extract day and hours/minutes from a date-time field to have them displayed in different columns. read my manual, done that. problem is though that my syntax is more or less as follows: select HOUR(hora) as lahora from mytable which returns the hour but with L prefixed, same for minutes, same for the date. but why? is it to do with datetype due to the "as" statement? and how could i avoid that. cheers, newbie tim -- Sent through GMX FreeMail - http://www.gmx.net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php