Re: Help Loading YYYYMMDD Dates
From: Doug Henderson <djhender_at_canuck.com>
Date: 1995/05/23
Message-ID: <3ptscm$q05_at_mp.canuck.com>#1/1
Date: 1995/05/23
Message-ID: <3ptscm$q05_at_mp.canuck.com>#1/1
You can instruct sqlload to perform any functions allowed in the values part of an insert statement.
To load a date field which contains 'YYYYmMdD' where blanks or non-zero digits appear in the 'm' and 'd' positions, try the following:
my_date position(1) date 'yyyymmdd' "translate(:my_date,' ','0')"
The translate function is applied before the date mask is used, and translates blank characters into zeros.
References:
Oracle 7 Server Utilities User's Guide part# 3602-70-1292 pp.6-71 to
6-71
Oracle 7 Server SQL Language Reference Manual part# 778-70-1292
p. 3-27
-- Doug Henderson, Glen Coulee Consulting, Calgary, Alberta [Sent by Free Agent 0.55]Received on Tue May 23 1995 - 00:00:00 CEST