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

Home -> Community -> Usenet -> c.d.o.server -> Re: Losing/missing data during INSERT

Re: Losing/missing data during INSERT

From: Venkatesh Krishnamoorthy <vkrishnamoorthy_at_worldnet.att.net>
Date: 1998/03/21
Message-ID: <6f34ss$p9q@bgtnsc03.worldnet.att.net>#1/1

If it is due to the date, try truncating the time. Oracel by default stores the time
in the date fields.Try to_char(date_field 'dd-mon-yyyy'); all the best

Venkatesh K Received on Sat Mar 21 1998 - 00:00:00 CST

Original text of this message

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