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: 
The following works on 2008R2+ to produce 'HH:MM':

```
select
case
when len(replace(replace(replace(right(cast(getdate() as varchar),7),'AM',''),'PM',''),' ','')) = 4
then '0'+ replace(replace(replace(right(cast(getdate() as varchar),7),'AM',''),'PM',''),' ','')
else replace(replace(replace(right(cast(getdate() as varchar),7),'AM',''),'PM',''),' ','') end as [Time]

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