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