SQL help kavalenu

[Cnu_rao0p]

Hello brothers,

 

I have a column that stores height in inches, I need to convert that column to feet and inches.  
The inches will need to be rounded to a whole number.  If the height is stored as 63.55300 (5 ft 3.5 inches) then it should round to 64 and display 5 ft,4 in inches column.  

 

 

[jalebibai]

use round function to get whole number 

then divide with 12 to get height and modulo 12 to get inches

Am I missing something? If you google it I'm sure the first result will be the solution

[Bhai]

19 minutes ago, jalebibai said:

use round function to get whole number 

then divide with 12 to get height and modulo 12 to get inches

Am I missing something? If you google it I'm sure the first result will be the solution

[vikuba]

step 1. round the heights . ( this will remain inches like 64, 65)

step2. divide resultant heights from step1 by 12

step3. round the resultant heights from step2