title: Find float column max scale and precision
body: <p>I have a column with datatype float in Teradata. I want to find the Maximum precision and scale for that column.</p>
  <p>Note: My column's scale part has more than 10 digits in most of the places.</p>
  <p>Sample Data</p>
  <pre><code>123.12321323002
  13123213.13200003
  33232.213123001
  </code></pre>
  <p>The output I need is
  Precsion 19 (scale + length of 13123213) and scale is 11 (length of 12321323002)
  or</p>
  <p>8 (length of 13123213), 11 (length of 12321323002).</p>
  <p>I tried to find them buy converting the column as varchar and splitting them based on the '.' and make the integer and fractional part as 2 columns and then finding the max length of 2 columns. But when I'm select the data, Teradata rounds off the scale part. So after that, if I convert them as char, I'm getting lesser value for scale part.</p>
  <p>For example:</p>
  <p>org data: 1234.12312000123101</p>
  <p>data when I select from Teradata: 1234.12312000123</p>