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

Tang Wai Shing, Willson writes:

>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;

                                      ^^         ^^
                                     Month      Month
                                              Replace with
                                             MI for minutes.

The problem is the trap of thinking MM is minutes. This bites everyone once.

David Jordan Received on Mon Mar 13 1995 - 20:19:42 CET