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.