DATE conversion

Database

DATE conversion

Hi,

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.

Tags (2)