decimal

Returns the decimal representation of "string-expression" using "precision-integer" and "scale-integer". The "decimal-character" can be used to specify the single-byte character constant used to delimit the decimal digits in "string-expression". The "string-expression" must be formatted as an SQL Integer or Decimal constant.   Alternate syntax: decimal ( numeric-expression [ , precision-integer [ , scale-integer ] ] ) Returns the decimal representation of "numeric-expression" using "precision-integer" and "scale-integer".

Syntax

decimal ( string-expression [ , precision-integer [ , scale-integer 
[ , decimal-character ] ] ] )