Getting ORA-01840: input value not long enough for date format Error
Hi All,
This is one of the strange errors I have come across in Oracle.
We have Special Information Types in Oracle HRMS and we store different values in SIT segments. We include certain dates as well in these segments ( per_analysis_criteria table). Though the segments are of datatype VARCHAR2, the date values get stored in below format :
'YYYY/MM/DD HH24:MI:SS'
e.g. Segment 4 ( Passport Valid From) : 2009/05/01 00:00:00
Segment 5 ( Passport Valid to) : 2010/05/01 00:00:00
We developed multiple views for reporting purpose for SIT data. View SQL :
SELECT ppa.person_id, fifs.id_flex_num, fifs.id_flex_code,
fifs.id_flex_structure_code, fifst.id_flex_structure_name,
This is one of the strange errors I have come across in Oracle.
We have Special Information Types in Oracle HRMS and we store different values in SIT segments. We include certain dates as well in these segments ( per_analysis_criteria table). Though the segments are of datatype VARCHAR2, the date values get stored in below format :
'YYYY/MM/DD HH24:MI:SS'
e.g. Segment 4 ( Passport Valid From) : 2009/05/01 00:00:00
Segment 5 ( Passport Valid to) : 2010/05/01 00:00:00
We developed multiple views for reporting purpose for SIT data. View SQL :
SELECT ppa.person_id, fifs.id_flex_num, fifs.id_flex_code,
fifs.id_flex_structure_code, fifst.id_flex_structure_name,
0