Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CONVERT GMT to EST TIME

574741Nov 30 2007 — edited Dec 1 2007
Hi
i want to fetch data from 00:01:00 to 23:59:00 EST TIME.
I am getting results even beyond that time. The reason is server runs on GMT time
I need data on EST time.
how to get data from that time only 00:01:00 to 23:59:00 est
emp_TimeStamp11 data type is DATE
emp_TimeStamp22 data type is DATE
emp_TimeStamp44 data type is DATE

sql query

select col1,col2,col3
from emp,dept
emp_idnr = dept_idnr
and emp_TimeStamp11 is not null
and emp_Timestamp22 is not null
and emp_TimeStamp11 >= to_date('2007-08-02 00:01:00','YYYY-MM-DD HH24:MI:SS')
and emp_TimeStamp44 <= to_date('2007-08-02 23:58:58','YYYY-MM-DD HH24:MI:SS')


I got the result. But i am getting more data than i excepted
I am getting data from 2007-08-01 from 2100 hrs onwards.
which is part of previous days data also which i do not want.
My server runs GMT time base.
I need the data from 0001 hrs to 2359 hrs EST
pl help
thx, N.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2007
Added on Nov 30 2007
3 comments
27,061 views