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: It works fine for Standard time. But for daylight savings time we need to convert it to ‘edt’ based on