extract hour/min from DATETME field

[zaver]

Hello

I want to get the hour and minutes from a datetime filed
I use :

SELECT EXTRACT(HOUR FROM date), EXTRACT(MINUTE FROM date) FROM table
or
SELECT HOUR(date), MINUTE(date) FROM table

Both of them work but i get the time in the following way:

if the time is e.g 05:00:00 i get 5:0 instead 05:00

Is there a way to show them as 05:00 ?

Thanks
zaver

[cgraz]

How about DATE_FORMAT() (see MySQL manual for usage)