Timestamp to date with an Oracle database
I believe that to change a field data type from timestamp to a date, I need to create a Calculated Field at the View level in freehand SQL. Can anyone provide the SQL statement for an Oracle database please? I have tried several suggestions from Stack Overflow, but I get errors.
Thanks and regards