i want to extract day and hours/minutes from a date-time field.
in order to to this i use e.g. for the hours:
select
HOUR(hora) as lahora
from mytable
which returns the hour but followed by an "L", same for minutes,
same for the date.
why is this so and how can i avoid it?
we run mySQL under Z
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 wi
