Greetings:

I have what should be a fairly simple date problem, but I am just not having
any luck getting it to work...

I have a table with a column of DATE type. This column is called CLSDDATE, and
all values in there are GMT based.

I have a server that's sitting in PST, and what I would like to do is create a
query of all rows that have a date value within the last hour, and for the
life of me, I cannot figure out how to get this to work...

I've tried the following, with no success..

SELECT WO_NUM,EMAILADDR FROM TASKS WHERE CLSDDATE > SYSTIMESTAMP - (60/1440);

Since all dates are in GMT, this gets everything within the past 9 hours,
which is not what I wanted... I know there's probably a simple way to do this,
but I am flummoxed...

Any thoughts/suggestions would be MUCH appreciated...

Thanks,
Richard.

"Richard Whittaker" <richpop (AT) connections (DOT) yk.ca> wrote

Have you tried this in the same session :

ALTER SESSION SET TIME_ZONE = local;

This sets the time zone to the operating system time zone.
It works for Oracle 9i, don't know about 8i/10g (you didn't specify your
Oracle version).


HTH
Matthias