Re: SQLLOADER vs. NULLIF

From: BobH <b-horton_at_worldnet.att.net>
Date: 1998/03/23
Message-ID: <6f7bj7$52i@bgtnsc03.worldnet.att.net>#1/1

well another question. Is the time based on 24hr clock or 12. the hour element HH or HH12 is hour of day (0-12). Use HH24 for Hour-of-day(0-23). so the time format would be 'HH24 MI SS' would be my next try. Before trying though, check the .bad file to see if the record has a 'military-time'.
B.H.

The McClures wrote:
>
> Just tried NULLIF first1 = BLANKS. Received the same error message. Note
> that the error message specifies the hour portion as being in error. I
> think it is doing fine with the date portion, but fails when it encounters
> the space, or the time portion. I'm open to any other suggestions...
>
> Thanks in advance,

>
> Jeff McClure
> Specialist DB Analyst
> Ameritech New Media
> Jeff.W.McClure_at_Ameritech.com
Received on Mon Mar 23 1998 - 00:00:00 CST