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: SQLLOADER vs. NULLIF

Re: SQLLOADER vs. NULLIF

From: J L Joslin <jljoslin_at_worldnet.att.net>
Date: 1998/03/29
Message-ID: <6flnjh$3dt@bgtnsc02.worldnet.att.net>#1/1 







On Mon, 23 Mar 1998 16:41:10 -0600, jeff.w.mcclure_at_ameritech.com
wrote:



>jeff.w.mcclure_at_ameritech.com




Try:



first1 date 'YYYY-MM-DD HH24:MI:SS' NULLIF(first1 = blanks)



Apparently, Informix is returning 24 hour time values.  This should
fix that.
Received on Sun Mar 29 1998 - 00:00:00 CST












Original text of this message













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