Syntax\n------\n\nTO_NUMBER(number_or_string_subject)\nTO_NUMBER(string_subject,string_format)\n\nDescription\n-----------\n\nThe function returns the DOUBLE data type for all signatures and input data types.\n\nThe format parser understands the following components:\n\n Digits: 0, 9\n Hex digits: X\n Group separators: comma (,) and G\n Decimal delimiters: period (.) and D\n Approximate number signature: EEEE\n Currency/numeric flags: $ and B\n Currency signatures: C, L, U\n Sign signatures: S, MI, PR\n Special format signatures: V, TM, TM9, TME\n Format flag: FM\n\nThe function was introduced for Oracle compatibility, but does not include the following features:\n\n The ON CONVERSION ERROR clause\n The third parameter (nlsparam)\n* Internationalized components: G, D, C, L, U\n\nThese features are planned to be be implemented via MDEV-36978.\n\nExamples\n--------\n\nSELECT TO_NUMBER('100.00');\n+---------------------+\n| TO_NUMBER('100.00') |\n+---------------------+\n|                 100 |\n+---------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/to_number