date conversion
Moderators: chulett, rschirm, roy
date conversion
Hi ,
I am trying to load the data from file to database.
file have one date column begin_date its data type is timestamp(19), target database column type is timestamp (38). while loading the data I am getting the error, date for mante not supporting.
can any one suggetst on this.
I am trying to load the data from file to database.
file have one date column begin_date its data type is timestamp(19), target database column type is timestamp (38). while loading the data I am getting the error, date for mante not supporting.
can any one suggetst on this.
I am using the following functionnivas wrote:use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.
Oconv(Iconv(DSLink44.BEGIN_DATE , "D YM"), "D4/MDY")
it inserting nulls. its not null col. so all are rejecting
deva wrote:I am using the following functionnivas wrote:use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.
Oconv(Iconv(DSLink44.BEGIN_DATE , "D MDY"), "D4/MDY")
it inserting nulls. its not null col. so all are rejecting
Deva,
First of all you need to provide the input date format looks like .
It is not possible for anyone of us to provide right solution without this information.
First of all you need to provide the input date format looks like .
It is not possible for anyone of us to provide right solution without this information.
Last edited by paddu on Tue Feb 12, 2008 12:48 pm, edited 1 time in total.
Iconv and Oconv have nothing to do with nullability. If your column contains nulls, add something like
Code: Select all
IF IsNull(DSLink44.BEGIN_DATE) THEN '01/01/2000' ELSE Oconv(Iconv(DSLink44.BEGIN_DATE , "D MDY"), "D4/MDY")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Are you talking about a NULL or an empty string? The former, in Server, can only occur if the input is already NULL!
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>