Xref: alice comp.databases.oracle.tools:21954
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: HowardParks@my-dejanews.com
Newsgroups: comp.databases.oracle.tools
Subject: Re: Can this be done with SQLLoader????
Date: Wed, 03 Mar 1999 15:16:08 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 13
Message-ID: <7bjjnd$5kd$1@nnrp1.dejanews.com>
References: <36DC2D27.FFE300B6@erols.com> <3zZC2.347$rS5.3331@news1.online.no>
X-Article-Creation-Date: Wed Mar 03 15:16:08 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; I)
X-Http-Proxy: 1.0 x16.dejanews.com:80 (Squid/1.1.22) for client 207.250.55.254

I have the date stuff wrong in my previous post.

If jdate is a date field, and the data looks like "99062", try:
jdate position(1:5) date "RRDDD"
No need for the to_date function.

Howard Parks
1 Peter 4:10



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own