Is there any chance that I can get date format as MMM'YY ??
how can we concatenate " ' " between month and year ??
You can use th following query.
SELECT SUBSTRING(MDate FROM 4 FOR 3) || '''' ||SUBSTRING(MDate FROM 1 FOR 2)
SELECT (YOUR_DATE_COLUMN (FORMAT 'YY-MMM-DD')) (CHAR(11)) AS MDate
SELECT CAST(CAST(CURRENT_DATE AS DATE FORMAT 'MMM') AS CHAR(3))
|| '''' ||
CAST(CAST(CURRENT_DATE AS DATE FORMAT 'YY') AS CHAR(2))