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!

Oracle 12c - Sql Query - Character to Number

SANPATMar 14 2022 — edited Mar 15 2022

Dear Friends
I want to select the data which is in character form (34:44) which i want to convert to number as (34.44).
I tried the following Query but its giving the error message, can you please suggest the correct syntex . clock_in is in Character ("34:44")
SELECT EMP_NO, TO_NUMBER('clock_in', '99.99'), OFF_DUTY,CLOCK_IN,CLOCK_OUT FROM ATT_BIOMATRIX_DRAFT

Sanjay

Added on Mar 14 2022

#dba

3 comments

113 views