DSXchange

Hi All,

Well i have a question , i'm here extracting data from the mainframes using cff and later doing some validation using transformer and finally loading into oracle table .
well few of the data from source has some fields which are dates but their datatypes are varchar
few sample data are
02/28/07
04/01/04
now my question is , in my oracle table these fields are of type timestamp.
well i converted the dates using oconv and iconv to 2007-02-28 , 2004-04-01
but the issue is , am i suppose to add the time values to it in order to change it to timestamp.
but the source data doesnt have any time attached to it .
what should i do about this issue now?
will the oracle table give any errors ?

Help needed

Thanks in advance

append zeros for hours minutes and seconds to the source data and make it as per oracles requirments.

sshettar wrote:2007-02-28 , 2004-04-01

Make them,
2007-02-28 00:00:00 and 2004-04-01 00:00:00 like advised.

What is the actual datatype in the Oracle table - DATE or some flavor of TIMESTAMP?

Thanks for the suggestions ,
but looks like oracle takes the time as 00:00:00 by default if that isnt presnt in the data .

depends on how your table was created.

no credits to oracle for that.