these are the souce and target
source oracle
column :U_LOAD_TS sqltype timestamp length:19
target oracle
column :U_LOAD_TS sqltype timestamp length:38
i am getting error
Attempt to convert String value "26-APR-06" to Timestamp type unsuccessful
date problem
Moderators: chulett, rschirm, roy
custom sql.
custom sql.
chulett wrote:What stages are you using? Generated or custom sql? ...
Re: custom sql.
adams06 wrote: stage :oracle OCI
custom sql.
chulett wrote:What stages are you using? Generated or custom sql? ...
You must use TO_DATE(...) functions on all columns that are DATE or TIMESTAMP datatypes. DS passes text strings that look like dates to Oracle, but your SQL must include this.
If you use GENERATED SQL, you'll see that DS automatically adds TO_DATE when writing and TO_CHAR when reading using the ORAOCI stages.
If you use GENERATED SQL, you'll see that DS automatically adds TO_DATE when writing and TO_CHAR when reading using the ORAOCI stages.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle