select pm_project__new_project_item ( :project_id, :project_name, :project_code, :parent_project_id, :goal, :description, :deadline_scheduling, to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), null, null, :ongoing_p, now(), :user_id, :peeraddr, :package_id ); UPDATE pm_projects SET project_name = :project_name, project_code = :project_code, parent_project_id = :parent_project_id, goal = :goal, description = :description, deadline_scheduling = :deadline_scheduling, planned_start_date = to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), planned_end_date = to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), ongoing_p = :ongoing_p WHERE project_id = :project_id select project_id, project_folder_id, project_name, project_code, goal, description, deadline_scheduling, to_char(planned_start_date,'YYYY MM DD') as planned_start_date, to_char(planned_end_date,'YYYY MM DD') as planned_end_date, ongoing_p FROM pm_projectsx where project_id = :project_id