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!

ORA-01722: invalid number error is coming when trying to extract only hrs,mins from the +000000000 00:21:56.377000 Format

AKV27Jun 28 2023

Hi All,

ORA-01722: invalid number error is coming when trying to extract only hrs,mins from the +000000000 00:21:56.377000 Format from the below query.Please let me know what I am doing mistake.

SELECT
to_char('erh.ELAPSEDTIME','HH24:MI:SS'),
ELAPSEDTIME

FROM ESS_REQUEST_HISTORY erh

Any help would be appreciated.

Thanks you!

Added on Jun 28 2023

#pl-sql, #plsql, #sql, #sqldeveloper

20 comments

722 views

3 mentions