6.25日报错
select '预算'as bud ,year as voucher_year ,period as voucher_period ,department_first_level,account_first_name,account_second_name,account_third_name,cast(budget as decimal(16,4)) as management_cny_amount
from fin_da_dev.fin_group_budget
报错：Cannot cast VARCHAR '31,127,861' to DECIMAL(16, 4).
原因：财务数据上传千分位和空格无法识别
--查询当月第一天
select trunc(‘2020-12-03’，‘MM’) – ‘2020-12-01’
