Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Timestamp

Re: Oracle Timestamp

From: Faby <stardust99_fr_at_yahoo.fr>
Date: 10 Aug 2006 03:03:57 -0700
Message-ID: <1155204237.603793.138310@75g2000cwc.googlegroups.com> 





Hi Martin,


Thank you for your reply. I need to convert my timestamp to a string as
i'd like to compare it to '01-AUG-2006'. I thought that
TO_CHAR(MYTIMESTAMP,'DD-MON-YYYY') < '01-AUG-2006' would do it, but
someone else from work told me to use


TO_DATE(SUBSTR(TO_CHAR(MYTIMESTAMP), 1, 9), 'DD-MON-RRRR') <
'01-AUG-2006' but i'm sure if he's right or not. Could you explain it,
please?


Thanks


Faby
Received on Thu Aug 10 2006 - 05:03:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US