Primavera (MOSC)

MOSC Banner

Hi, While running solution (Doc ID 2114150.1), the solution applied written in SQL Plus (Oracle DB))

edited Oct 9, 2023 8:41PM in Primavera (MOSC) 1 commentAnswered

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center