Monday, 1 April 2019

Convert Kilometers to Miles in TQSL




To convert Kilometeres to Miles in Tsql Try this

CAST(ISNULL(tblManifestos.km, 0) * 0.62137 AS decimal)

Multipy the kilometers by 0.62137

The to round it to the nerest mile cast as a decimal



-
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...

  • Emergencies go bag(s)
      Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • USB safe charging
      Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...