Loading data from Oracle table to Oracle table
There is no source for this column
I created one MOD_DATE column in transformer
I need Date with timestamps in the target column
target table has MOD_DATE data type is DATE
I can load the date but not able to load date with time stamp
Any ideas I tried many ways could not find a solution any help appreciated?
DATE To TIMESTAMP
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
DATE To TIMESTAMP
Thanks,
M
M
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
If i make date to timestamp then it is loading date.
I tried this DSJobStartDate:CurrentTimestamp() in the transformer for mod_date column it is loading date only when the datatype is changed to date in transformer but if i change to time stamp then also it is loading date in the target column
now my question is can we load time stamp into date datatype?
any ideas to over come the issue?
I tried this DSJobStartDate:CurrentTimestamp() in the transformer for mod_date column it is loading date only when the datatype is changed to date in transformer but if i change to time stamp then also it is loading date in the target column
now my question is can we load time stamp into date datatype?
any ideas to over come the issue?
Thanks,
M
M
Oracle's Date datatype is a timestamp internally, so you should load it with a timestamp column if you are wanting specific time information. However, the default view for that datatype only shows the date. Google for "Oracle date datatype"...Databasejournal.com has a good explanation of the datatype.
The method you used to build your timestamp was incorrect...you're concatenating a data and a timestamp. DSJobStartDate:CurrentTimestamp() would end up building a string looking like "2011-02-152011-02-15 19:52:12" (you're using the concatenation operator : so the date and timestamp are first converted to strings).
Build your timestamp correctly. CurrentTimestamp(), DSJobStartDate : ' 00:00:00', or whatever you need to store in the column. Leave the datatype as timestamp when it loads. Then view the column correctly in Oracle to see the time portion of the timestamp.
Regards,
The method you used to build your timestamp was incorrect...you're concatenating a data and a timestamp. DSJobStartDate:CurrentTimestamp() would end up building a string looking like "2011-02-152011-02-15 19:52:12" (you're using the concatenation operator : so the date and timestamp are first converted to strings).
Build your timestamp correctly. CurrentTimestamp(), DSJobStartDate : ' 00:00:00', or whatever you need to store in the column. Leave the datatype as timestamp when it loads. Then view the column correctly in Oracle to see the time portion of the timestamp.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am