Oracle SQL Sysdate Time Zone Problem
Posted on 2009-07-16
I have a table order. It has two columns apmt_date and apmt_time_zone.
we are storing time zones like P, M, C, E and empty. TIme Zones must be appended ny T at last.
That means P = PT, C = CT etc.
Now i have query like below
select * from order where apmt_date > sysdate.
Iam having problem here as iam not checking with time zones. I dont know the time zone of that oracle db instance.
I want a query which will also take care of time zones.