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