Date zone from GMT to EST

Hi all,

I have a object in the universe (to_char((GH_LOCAL.GLOBAL), ‘MM/DD/YYYY HH24:MI:SS’)) its in GMT, i need to change the time zone in to EST,

Can anybody give me the query for that

FYI my database is oracle 9i


thamil (BOB member since 2008-07-30)

Hi all,

This is the query for changing the time zone .

to_char(New_time (GH_LOCAL.GLOBAL), ‘gmt’,‘est’), ‘MM/DD/YYYY HH24:MI:SS’)


thamil (BOB member since 2008-07-30)