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: 
If you want to display 24 hours format use: 

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

```

and to display 12 hours format use: 

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

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