I need a way to update a field in a table with a numeric number. The field (Hours) has a datatype of "float" so if were to update this field like so
set hours = '4.0'
where issuenumber = 'xxxx'
I get a displayed number that doesn't resemble the intended 4.0 hours.
So I'm looking perhaps for a sql function that will take the 4.0 hours and convert and imput them into the database so that when displayed shows the 4.0 hours.
Any help will be appreciated.