Question: I want to get only `hh:mm` from date. 

How I can get this?

I have tried this :

```
CONVERT(VARCHAR(8), getdate(), 108)

```

Answer: 
You can easily use Format() function instead of all the casting for sql 2012 and above only

```
SELECT FORMAT(GETDATE(),'hh:mm')

```

This is by far the best way to do the required conversion.
TO\_CHAR(SYSDATE, 'HH')
I used this to get the current hour in apex PL/SQL