Selecting time from datetime

[Anon]

Dear All,
I am picking up a value from some table which is a "datetime" datatype. How can I select only time value in this field using a MySQL query? But kindly don't say that

select extract(hour_second from "2002-01-01 12:10:10");

will work because I have to pick time from a database field.
thanks,
regards,
Indrajit.

[Anon]

See the following sites:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html

http://www.mysql.com/doc/D/a/Date_calculations.html