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;

                                               ^^ should be MI :P

Thanks to some oracle guru, it is due to my typo-error. Once it is MI, it works fine. Sorry for wasting bandwidth here 8-P

--
Tang Wai Shing, Wilson				email: cswstang_at_cs.ust.hk
Department of Computer Science, HKUST, HK	tel# : (852)-358-7004