Hi, While running solution (Doc ID 2114150.1), the solution applied written in SQL Plus (Oracle DB))
Hi, While running solution (Doc ID 2114150.1), the solution applied written in SQL Plus (Oracle DB) while running the DB in MS SQL environment, would you please guide me how to run below script in MS SQL, since it provides errors when execute, thanks
UPDATE ADMUSER.FINDATES
SET FIN_DATES_ID = <FIN_DATES_ID of problem record> '// example fin_dates_id found as a result of step #2 above.
, FIN_DATES_NAME = '<FIN_DATES_NAME>'
, START_DATE = to_date ('<FIN_DATES_NAME>', 'YYYY-MM-DD')
, END_DATE = to_date ('<FIN_DATES_END_NAME>', 'YYYY-MM-DD')
, CREATE_DATE = to_date ('<CREATE_DATE>', 'YYYY-MM-DD HH24:MI:SS')