How do you split a field from datasource SQL? Can you do this straight when you are querying the data from SQL or do you have to do this when I am exporting to excel. The reason I want to do this is when a date and time are together and it is exported to excel it messes up its format turning into a number. Please let me know which to do and provide an example ASAP. thanks!

OR I need away to set the format of the column with the format yyyy-mm-dd hh:mm. Thanks- possibly in excel.view.php file

Do I use this ->pipe(new ColumnMeta(array(

    'type' => 'yyyy-mm-dd hh:mm',

If so how and where?