question

RizalValry avatar image
0 Votes"
RizalValry asked RizalValry answered

Please Help me, I Got Error : Argument data type int is invalid for argument 2 of format function in Query SQL SERVER

131314-typedata.png131207-saldo-awal.png

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


sql-server-generalsql-server-transact-sql
saldo-awal.png (6.3 KiB)
typedata.png (14.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

RizalValry avatar image
0 Votes"
RizalValry answered

Sorry, I Have Solution from my questions guys
hehe

I just need to change parameter 0 to 'N0' and it's what I expected :)

Like This :
SELECT
saldoawal.id,
format(saldoawal.saldo_awal,'N0') AS saldoAwal,
format(saldoawal.bayar_ke_vendor,'N0') AS byrKeVendor,
format(saldoawal.tagihan_ke_nasabah,'N0') AS tagKeNasabah,
format(saldoawal.akhir,'N0') AS salAkhir
FROM
vm.saldoawal
WHERE
saldoawal.record_code = '1' AND
saldoawal.code = '980001'

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.