JDBC SND channel - UPDATE local time (China)

[Former Member]

Dear Experts,

I am
trying to Update local time using below statement in JDBC SND communication channel.
But its not updating time properly, but same Update statement is working OK
while using in Oracle DB directly. please advise right approach for updating
local time.

UPDATE
TABLE_NAME SET STATUS='PI',LAST_UPDATE_DATE =
TO_CHAR(sysdate,'YYYY/MM/DD'),LAST_UPDATE_TIME = TO_CHAR(systimestamp at time
zone 'UTC','HH24:MI:SS') where MQSID,TANUM,LGNUM,TAPOS in (SELECT * from
(SELECT * from T_TRASCONFIRM_INTF where STATUS='OPEN' order by
MQSID,TANUM,LGNUM,TAPOS) where rownum <= 100

Please let me know where it’s going wrong.

FYI. LAST_UPDATE_DATE and LAST_UPDATE_TIME are declared as VARCHAR2 type in DB

Regards,

Satish

[former_member182455]

Hi,

please compare the Date time formate in PI and Database.

Regards

srinivas

[Former Member]

Hi Srinu,

I am trying to Update it from SQL statement in JDBC channel, So I am setting the date format as required by DB.

(sysdate,'YYYY/MM/DD'),LAST_UPDATE_TIME = TO_CHAR(systimestamp at time

zone 'UTC','HH24:MI:SS')

Is sql statement in JDBC channel and Direct DB statement should have any syntactic deference? Or can be both same ?

Regards,

Satish.

[Former Member]

Hi experts ,

Any inputs on updating date and Time ?

Regards,

Satish