[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>
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-7004Received on Sun Mar 12 1995 - 16:15:47 CET