I am reading data from oracle database to excel file. There is a column with data datatype "18-08-2018", but when extracted to excel it is showing as "Sat Aug 18 18:35:08 IST 2018".
I tried extracting as string from db, but then I got result in excel file as "2018-08-18 18:35:08.0".
I want my output in excel to "18-08-2018". Can anyone help me out?
If you open a file with Excel, it will reformat the data according to the date settings.
When you are doing data testing and file analysis, the recommendation will be always to open the file with a normal text editor like notepad++, textpad etc. to understand the layout. These editors will not modify the data during presentation layer and will show "as-is" from the file.
