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: 
Just use the first 5 characters...?

```
 SELECT CONVERT(VARCHAR(5),getdate(),108) 

```
TO\_CHAR(SYSDATE, 'HH')
I used this to get the current hour in apex PL/SQL