

I use the following query :
SELECT
saldoawal.id,
format(saldoawal.saldo_awal,0) AS saldoAwal,
format(saldoawal.bayar_ke_vendor,0) AS byrKeVendor,
format(saldoawal.tagihan_ke_nasabah,0) AS tagKeNasabah,
format(saldoawal.akhir,0) AS salAkhir
FROM
vm.saldoawal
WHERE
saldoawal.record_code = '1' AND
saldoawal.code = '980001'
and get error message :
Msg 8116, Level 16, State 1, Line 1
Argument data type int is invalid for argument 2 of format function.
Completion time: 2021-09-12T11:33:24.9509126+07:00