I have a query which exports data from Oracle to Excel. One of the columns is a datetime column. MM/DD/YYYY HH:MM:SS. I only need the date. In the SQL I changed it read
to_char(FieldName,'MM/DD/YYYY'). This works fine but it converts it to a string, which is creating problems when sorting.
Any thoughts...thanks as always for the help.