I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now I have to convert this to Eastern standard/daylight savings time while retrieving. I am using the below query for this:
select to_char (new_time(application_recv_date,'gmt','est'), 'MON dd, YYYY') from application
It works fine for Standard time. But for daylight savings time we need to convert it to 'edt' based on timezone info. I am not very sure on how to do this. Please help me out
See Question&Answers more detail:os