CONVERT GMT to EST TIME
574741Nov 30 2007 — edited Dec 1 2007Hi
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.