Hi guis i'm new i need hel for a query

i have two table created by hibernate from java Date Object and type TIMESTAMP

now i need to retrive data with a query than match only the time part (HH:mm) of the the SQL column

the query i use is

@NamedQuery(name ="findAppuntamentiBySportelloDataSlot", query = "from Appuntamento a where (a.sportello.idSportello = :idSportello and a.dataApp = :d1 and a.timeStartApp = :ts )")
where ts and timeStartApp is with dd/MM/yyyy HH:mm:ss in the sql.

i need to retrieve all record which time part (HH:mm) of timeStartApp match the time part (HH:mm) of variable ts

some one can help me?

thank you

Pietro