how to get right substring using sql in spark 2.0
<p>e.g. If I have a string column value like "2.450", I want to get right 2 characters "50" from this column, how to get it using sql from spark 2.0.1
I am running my sql on view created from dataframe</p>

<pre><code>mydf.createOrReplaceTempView("myview");
</code></pre>