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