Concatenate string [closed]

-2

I want to concatenate the current day with the "0" character, but I'm not getting it.

string diaAtual = DateTime.Now.ToString("d");
string diaFormatado = diaAtual+"0";

I need to do this to insert into a select that I'm using. Because in the database the date is in a different format. Day 01 is 10, Day 02 is 20 and so on. So I'm using the following select to get the dates smaller than today

SELECT COUNT(DISTINCT SALES_ORDER) AS SALES_ORDER, COUNT(DISTINCT DELIVERY) 
AS DELIVERY, COUNT(MATERIAL) AS MATERIAL 
FROM V_CABOS WHERE DT_INI IS NOT NULL AND DT_FIM IS NULL AND PRIORIDADE < 30

Only in the place of the day that means 3 (current day), I want to put the concatenation that in the case would be diaFormatado.

    
asked by anonymous 03.10.2018 / 16:51

1 answer

1

To get the current day with two houses you should use the command:

string diaAtual = DateTime.Now.ToString("dd");
    
03.10.2018 / 17:01