

 Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# Teradata-style formatting characters for numeric data
<a name="r_Numeric-format-teradata"></a>

Following, you can find how the TEXT\$1TO\$1INT\$1ALT and TEXT\$1TO\$1NUMERIC\$1ALT functions interpret the characters in the input *expression* string. You can also find a list of the characters that you can specify in the *format* phrase. In addition, you can find a description of the differences between Teradata-style formatting and Amazon Redshift for the *format* option. 

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/redshift/latest/dg/r_Numeric-format-teradata.html)

## Data formatting characters for Signed Zone Decimal, Teradata–style numeric data formatting
<a name="r_Numeric-format-teradata-signed-zone"></a>

You can use the following characters in the *format* phrase of the TEXT\$1TO\$1INT\$1ALT and TEXT\$1TO\$1NUMERIC\$1ALT functions for a signed zoned decimal value. 

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/redshift/latest/dg/r_Numeric-format-teradata.html)