Oracle Database Discussions

Hi,

select systimestamp from dual;

08/16/2011 12:38:57.765296 PM -05:00

I want it to return:

08/16/2011 12:38:57.765296 PM EST

I know I can get it by setting

alter session set time_zone = 'EST'

however I do not know whether to set it to EST or EDT.

So I want to know how to map the -05:00 to EST, +5:50 to IST and so on using a seeded function.

thanks

Guru.