NUMERIC

Description

The NUMERIC function is a system function that casts a string value into a numeric value.

This function is fully supported in Snowflake.

Grammar Syntax

select "numeric"(VARCHAR);

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT "numeric"('2024');

Results

"numeric"
2024

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT
TO_NUMERIC('2024');

Results

TO_NUMERIC
2024

Related EWIs

There are no known issues.