Format withing SELECT statement VB.Net

Question

    hi all

i am selecting date from a table. the select statement returns as dd-MMM-yyyy hh:mm:ss tt

instead of this current format i want it to just return the time. how can i do that. is there any way of formating within the SELECT statement

i know most of you must be saying to use Format(date, "hh:mm:ss tt") but how to use it within the SELECT statement.