You can translate the question and the replies:

formatting date to ddMMMyyyy which is equivalent to date9

Good day 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. regards N
user
16-07-2020 09:22:04 -0400

1 Answer

Hi, I would refer to the similar community question [here](https://community.denodo.com/answers/question/details?questionId=9064u0000004FgYAAU&title=formatting+date+to+ddMMMyyyy+which+is+equivalent+to+date9) for the answer. Hope this helps!
Denodo Team
20-07-2020 00:47:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here