ORA-01830: date format picture ends before converting entire input string
The error coming only for the below timezone preferences in the query handled on the custom program (to calculate promise date)
Preference : Russian Federation
Time zone : (GMT +3.00) Moscow
Query:
SELECT to_date(to_char(CAST( to_char(from_tz(CAST('25-OCT-21'' 11:59:59 PM' AS TIMESTAMP), 'Europe/Moscow') at TIME ZONE 'GMT', 'DD-MON-RRRR HH:MI:SS AM') AS TIMESTAMP),
'DD-MON-YYYY HH:MI:SS AM'),
'DD-MON-YYYY HH:MI:SS PM')
--- INTO lv_promise_date
FROM dual;
Kindly assist with the query finetune with appropriate function to be used.
Preference : Russian Federation
Time zone : (GMT +3.00) Moscow
Query:
SELECT to_date(to_char(CAST( to_char(from_tz(CAST('25-OCT-21'' 11:59:59 PM' AS TIMESTAMP), 'Europe/Moscow') at TIME ZONE 'GMT', 'DD-MON-RRRR HH:MI:SS AM') AS TIMESTAMP),
'DD-MON-YYYY HH:MI:SS AM'),
'DD-MON-YYYY HH:MI:SS PM')
--- INTO lv_promise_date
FROM dual;
Kindly assist with the query finetune with appropriate function to be used.
0