Export DSE to CSV

Question

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column. I want the date & time . here is my table on UI: 
 
 here s the column in db: 
 
 here is the CDT column: 
 
 and here is the csv column:

venkateswarak7510 · Accepted Answer

The problem is in the Excel tool whereyou need to change the format of the column as shown in the below image so that you can see date and time