Re: [Q] How to cmp the timestamp at all_objects?

Tang Wai Shing Wilson (cswstang_at_cs.ust.hk) wrote:
: 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
: --
: Tang Wai Shing, Wilson email: cswstang_at_cs.ust.hk
: Department of Computer Science, HKUST, HK tel# : (852)-358-7004

Your problem is the format. Instead of HH24:MM:SS use HH24:MI:SS. This will work for you. I've gotten stumped on this one myself.

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer