Date Format issue in Export SQL to Excel Smart Service : Date with Time-stamp is not exported

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

  • I have done formatting of Excel base template columns
  • Changing datatype 

But no luck !!!! Please share your thoughts on the same. 

 Discussion posts and replies are publicly visible