Skip to content

Feature: support to_number function #18089

Closed
@sundy-li

Description

@sundy-li

Summary

Description for this feature.

If precision, scale are not provided, the datatype should be decimal(38, 0)

TO_DECIMAL( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )

TO_NUMBER( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )

TO_NUMERIC( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )
TRY_TO_DECIMAL( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )

TRY_TO_NUMBER( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )

TRY_TO_NUMERIC( <expr> [, '<format>' ] [, <precision> [, <scale> ] ] )

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions