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]