DateTime export issue

[williot]

Hello,

When exporting DateTime column to xls or txt file, the time part of the value is always 00:00:00.
I've tryed this

exp.DataFormats.DateTime = "d/M/yyyy H:mm";

and that

static void exp_GetDataParams(object sender, Spire.DataExport.EventArgs.DataParamsEventArgs e)
{
if (e.Col == 1)
{
e.FormatText = "d/M/yyyy H:mm";
}
}

with no success.

Any answer to this problem ?

Regards.

[harry.support]

Hi,
Sorry for any inconvenience caused by us.
That's an issue left over by compatibility of data type of different database. We plan to fix it in the next release.
At present, I suggest you format DataTime type column in your SQL (if you use SQLCommand) or in your code (if you use DataTable) before exporting operation.