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: to_char put into a date?

Re: to_char put into a date?

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 20 Sep 2001 00:20:13 -0700
Message-ID: <c18ea449.0109192320.260b5f72@posting.google.com> 





The problem is your time_processed field is not a date type column.
You can only do date arithmetic between two date fields. By doing what
you did, you converted the char column to date so it worked. Its no
fluke and it is the right fix in this instance. (unless of course you
change the column from char to date).
Received on Thu Sep 20 2001 - 02:20:13 CDT












Original text of this message













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