Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cast function not working for few records

User_7LX0TNov 9 2022

Hi All,
When i am trying to convert timestamp to cast it is working for few records and for few records it is not working and giving this error.
"ORA-01878: specified field not found in datetime or interval".
'TO_CHAR(CAST(wcad.ACTIVITY_START_DATETIME AT TIME ZONE wlaf.time_zone AS DATE),'HH:Mi AM','nls_date_language=American')' this is the code i have used in my query.

Could you please help me on the same.
Thanks & Regards

Comments
Post Details
Added on Nov 9 2022
6 comments
289 views