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...

  • 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...
  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • 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...