You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error : ORA-01861: literal does not match format string

This is my query :

WITH details AS (

SELECT ppl.person_number,

  ppl.person_id ,

  pet.base_element_name,

  pee.effective_start_date start_date,

  TO_DATE(peev.screen_entry_value, 'YYYY-MM-DD HH24:MI:SS') seniority_date,

  '5 years' renewal_cycle,

  ADD_MONTHS(TO_DATE(peev.screen_entry_value, 'YYYY-MM-DD HH24:MI:SS'), 60) anniversary_date,

  grd.name grade,

  flv.meaning worker_category,

  ppnf.display_name name,

  ple.name legal_employer

  

FROM  per_person_secured_list_v ppl,

  pay_element_types_f pet,

  pay_element_entries_f pee,

  pay_input_values_f piv,

  pay_element_entry_values_f peev,

  per_assignment_secured_list_v paf,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!