The KM2MILES and MILES2KM Functions

[JimKnicely]

1 mile equals 1.6093440000000016479682560000017 kilometers and 1 kilometer equals 0.62137119223733333333333333333333 miles…

But who wants to remember those facts?

If we need to do either of these conversions in the database, we can simply use the KM2MILES function to convert kilometers to miles and the MILES2KM function to convert miles to kilometers!

Examples:

Code: Select all

cognos=> SELECT KM2MILES(300),
cognos->        MILES2KM(186.4113576712);
    KM2MILES    | MILES2KM
----------------+----------
186.4113576712  |     300
(1 row)

Code: Select all

dbadmin=> SELECT MILES2KM(70)        "PA Turnpike Speed Limit (Km)",
dbadmin->        KM2MILES(8850)      "Great Wall of China Length (Miles)",
dbadmin->        KM2MILES(4.5061632) "Pacific Ocean Average Depth (Miles)";
 PA Turnpike Speed Limit (Km) | Great Wall of China Length (Miles) | Pacific Ocean Average Depth (Miles)
------------------------------+------------------------------------+-------------------------------------
                    112.65408 |                   5499.13505130041 |                                 2.8
(1 row)

Note: These functions are not available by default. You'll have to install the Geospatial SQL Functions! Check the SQL Reference manual to see how to install them.