terra-models/macros/change_to_decimal.sql
2022-10-17 11:52:12 -05:00

5 lines
127 B
SQL

{% macro change_decimal(column_name,decimal_place=6)-%}
{{column_name}}/pow(10,{{decimal_place}}) :: INTEGER
{%- endmacro %}