Oracle DB Account Import - unable to set DateTime Fields

[piyushm]

Hello,

I am getting below error when mapping any date fields to datetime fields in Saviynt.

No signature of method: oracle.sql.TIMESTAMP.replace() is applicable for argument types: (java.lang.String, java.lang.String) values: [\, \\]

The Target columns are

Last_Login with datatype TIMESTAMP(9) WITH TIME ZONE

PASSWORD_CHANGE_DATE with datatype DATE

The Saviynt columns I am trying to map these to are

lastlogondate with datatype datetime

TARGETLASTPASSWORDCHANGE with datatype datetime

I have tried below options.

SYS_EXTRACT_UTC(last_login)

to_date((to_char(last_login AT TIME ZONE 'UTC','Mon dd,yyyy HH24:MI:SS')),'Mon dd,yyyy HH24:MI:SS')

cast(last_login AT TIME ZONE 'UTC' as DATE)

Please let me know how these values can be converted to datetime that is expected by saviynt.

[rushikeshvartak · Accepted solution]

TO_CHAR(PWD.PTIME , 'YYYY-MM-DD HH24:MI:SS') AS LASTPASSWORDCHANGE

[piyushm]

Thanks Rushikesh, This format is working.