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
Loading into Oracle table
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Re: Loading into Oracle table
Make them,sshettar wrote:2007-02-28 , 2004-04-01
2007-02-28 00:00:00 and 2004-04-01 00:00:00 like advised.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio