I try to export a datatable to Excel but in some date columns I export them in number, I already tried sending from the database the information I need but it does not work.
I try to export a datatable to Excel but in some date columns I export them in number, I already tried sending from the database the information I need but it does not work.
Before exporting, make a change to the data type of the column, better if you take it to a Varchar and when exporting it to the excel it will take it as Varchar
Select CONVERT(VARCHAR,fecha, 10) AS FECHA FROM TABLA