i need convert a date field in UTC to GMT-5, this is my query;

```
Select 
A1.NAME23,
TO_CHAR(A1.TIME_END,'YYYY/MM/DD HH24:MI:SS')TIME_END,
A1.VAR43 
From table

```

i trying this

```
select  to_char(cast(A1.TIME_END at time zone 'GMT-5' as date ),'YYYY/MM/DD HH24:MI:SS') as GMT-5 from table

```

but dont work

any suggestions

thanks.