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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.