SQL & PL/SQL

hi all,

We have a problem in making a query on the HTMLDB 10G database over a period
of time. Our HTMLDB 10G database server is at
US and is set to PST time zone , where as we log the customer cases from
India in IST .Say for
example if a case is recorded on HTMLDB 10G at around
3:15pm(IST), the same gets saved on the database as 2:44am (PST).
Now if i query from oracle client in India to
retrieve a case which has been logged after 3pm then the case which was
actually recorded at 3:15(IST) does not get displayed from Oracle.
Is there a way out to solve the problem of getting the correct data
from the database using IST timings. If I have created a case at
3:15pm(IST) , i should be able to retrieve the same case with the same creation time
from oracle too. We are not too keen on changing the server time to IST . I
wanted to know if it is possible to do the PST to IST conversion from the
client end while generating the query without changing the server
timestamps. It would be really great if someone can advise on this issue.
Thanks in advance.