I have a datetime format represented as 07DEC2005:00:00:00.000000 please note this is a date not character.
I now want to convert to 'ddMMMyyyy' but still to be in a date format not as text or character.
i have tried this sql code formatdate('ddMMMyyyy', open_date) AS OPEN_DATE but this returns a string not sas date numeric for example date9 format.
i have look at many example but they don't show pictures on how initially the data looked like.
Please allow us to share screenshots.