1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
3
Start with TO_CHAR function to format
https://docs.aws.amazon.com/redshift/latest/dg/r_TO_CHAR.html and https://docs.aws.amazon.com/redshift/latest/dg/r_Numeric_formating.html
and the following example can help you
SELECT TO_CHAR(your_decimal_column, 'FM9999999990.00') AS formatted_decimal
FROM your_table;
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 6 mois
- demandé il y a 6 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
Hi @sdtslmn thanks so much for responding! We need the data to be in decimal for calculations. Is that not possible?