Loading into Oracle table

[sshettar]

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

[Krazykoolrohit]

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

[I_Server_Whale]

2007-02-28 , 2004-04-01

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

[chulett]

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

[sshettar]

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

[Krazykoolrohit]

depends on how your table was created.

no credits to oracle for that.