I need to convert date, which is in the format 'MM/DD/YYYY', to the target format 'DD-MMM-YY'. I tried the following query and it worked too.
SELECT UPPER(CAST(CAST(CURRENT_DATE AS DATE FORMAT 'DD-MMM-YY') AS CHAR(9)));
I would like to know if there is any other better way I can get this done.
Note: The reason why I used UPPER() is because I wanted to simulate exactly what SYSDATE of ORACLE would return.