Oracle Timestamp

From: Faby <stardust99_fr_at_yahoo.fr>
Date: 10 Aug 2006 00:58:39 -0700
Message-ID: <1155196719.271331.102430@b28g2000cwb.googlegroups.com>

Hi,
I was wondering how I should convert a timestamp to compare it to '01-AUG-2006'. Is any of the following right?

TO_CHAR(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'

TO_DATE(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'

TO_CHAR(MYTIMESTAMP,'DD-MON-YYYY') < '01-AUG-2006'

If you could give a brief explaination of why I am getting a different result for each of the previous answer, i would really appreciate.

Thank you
Faby Received on Thu Aug 10 2006 - 02:58:39 CDT