We are using Export SQL to Excel Smart Service. In Database table we have two date-time columns. If smart service executes and generates the excel file,it always gives date time columns in date format. Our requirement is to have dateTime in reported excel sheet.
Below steps are tried from my end
But no luck !!!! Please share your thoughts on the same.
Discussion posts and replies are publicly visible
@mohammadez - Have you ever resolved this issue? I am running into the same problem.
I was able to resolve this - If you're still having an issue - include 'CAST datetimefield AS CHAR' in your select statement. That worked for me.