SQL & PL/SQL

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!

ora-01878: specified field not found in datetime or interval

RinneNov 13 2009 — edited Nov 13 2009

select max(to_char(from_tz(to_timestamp(to_char(timeabc, 'MM/DD/YYYY HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS'), 'Australia/ACT') at time zone 'US/Pacific', 'hh24'))
from table1

When I run the above query, I get the ora-01878: specified field not found in datetime or interval error. timeabc column in my table is a date field. I think I'm using the wrong time zones. Help please.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2009

Added on Nov 13 2009

9 comments

13,126 views