Postgresql... How to find current timezone EST or EDT, I am doing it But expecting simple solution for all timzone., : Postgresql... How to find current timezone EST or EDT, I am doing it But expecting a simple solution for all timezone.,

Exact requirements: if I gave ET as local timezone I need current timezone with daylight.

SELECT 
(CASE WHEN ((CURRENT_TIMESTAMP AT TIME ZONE 'America/New_York') - CURRENT_TIMESTAMP = '-04:00:00') then 'EDT' 
WHEN ((CURRENT_TIMESTAMP AT TIME ZONE 'America/New_York') - CURRENT_TIMESTAMP = '-05:00:00') then 'EST' 
ELSE ('OTH') END)