about inputoracle to Mysqloutput

[Anonymous]

hi

i have open studio DI 6.5.1.  and i trying to run a job with oracleinput to mysqlouput

oracle query is "select to_date(substr(startdate,1,15),'YYYYMMDD HH24MISS') as startdate from a_table"

and the data insert into mysql to "0000-00-00"

please, let me know anybody.

[Anonymous]

hi..

i tried to do as below images.  but the data set 0000-00-00 on mysql,

So, i changed my sql of oracle : "select substr(p.startdate,1,15) as startdate from awlotproduct where rownum<=10"

and data has been inserted on the mysql correctly.

Actually, data type the startdate column is char, so, i didn't need converting CHAR to TO_DATE.

i just wanna know how to insert to_date type on the mysql.

[manodwhb]

i am not sure about mysql,since i am familiar with Oracle.

is YYYYMMDD HH24MISS format is allowed in mysql?

[manodwhb]

still you have issue?

[Anonymous]

hi Manohar

i sorry for late replay.

Ok. mysql not allow date format to_date(startdate,'YYYYMMDD HH24MISS').

it may change to "str_to_date(startdate,'%Y%m%d %H%i%s')"

as i mention, i changed sql statement of oracle. so, the problems was fixed.

I really appreciate your time and effort to help.

[manodwhb · Accepted solution]

@bangu00,please accept the solution.