Home Forums SQL Server 2008 SQL Server 2008 - General How to convert kilograms to pounds and ounces RE: How to convert kilograms to pounds and ounces
NineIron
SSChampion
Points: 12529
More actions
December 29, 2017 at 8:48 am
#1973838
Given a weight of 68.6 kg. Is this the best way to do it?
selectconcat(floor((68.6*2.2)),' lbs ',((68.6*2.2)%1)*16,'oz') as PtWeight