I have raw data being imported into a table as varchar and need to convert it into numeric 2 place decimal format. The data comming represents time in terms of hour and minutes. Data looks like this:
When converted it should look like:
Insert into t_employee_detail
select CAST(f7 as numeric(8, 2))
But that didn't do it. How do I do this?