[Q] How to cmp the timestamp at all_objects?

From: Tang Wai Shing Wilson <cswstang_at_cs.ust.hk>
Date: Sun, 12 Mar 1995 15:15:47 GMT
Message-ID: <1995Mar12.151547.9120_at_uxmail.ust.hk>


Hi there,

I need to compare the timestamp of all_objects with a date field (e.g SYSDATE). However, I hit error like when I do the following:

select * from all_objects where
to_date(all_objects.timestamp, 'YYYY-MM-DD:HH24:MM:SS') < SYSDATE;

Then error is:
ORA-01810: format code appears twice

I think the problem is all_objects is just a view, which have its timestamp being converted (to_char) from a date file, and oracle does not allow me to "convert-and-recovert" things back. Any idea to by-pass it?

P.S. All I could think of is to use sys.obj$ directly, but I don't like this very much :(

--
Tang Wai Shing, Wilson				email: cswstang_at_cs.ust.hk
Department of Computer Science, HKUST, HK	tel# : (852)-358-7004
Received on Sun Mar 12 1995 - 16:15:47 CET

Original text of this message