Categories: Conversion

TO_NUMBER

Converts a string into a number (double) in the specified format.

Syntax

TO_NUMBER(expression varchar, format varchar) → double

  • expression: String to convert to a number.
  • format: Format for number conversion.

Examples

SELECT TO_NUMBER('12374.0023', '#####.###')
-- 12374.002
SELECT TO_NUMBER('12374', '#####')
-- 12374.0