MSSQL Convert date and number to string

DECLARE @tanggal datetime = '2020-01-01 15:01:01'
declare @angka numeric(19,4) = 12345000000.456

SELECT @tanggal [SAMPLE DATE]
, CONVERT(VARCHAR(11), @tanggal, 106) [FORMAT DATE]
, REPLACE(CONVERT(VARCHAR(17), @tanggal, 113), ':', '.') [FORMAT DATETIME]
, @angka [SAMPLE NUMBER]
, FORMAT(@angka, '#,0.00') [FORMAT DATETIME]

Komentar

Postingan Populer