Dear all
I have a doubt,how to convert the INTERVAL DAY TO SECOND to character format
For eg:
SELECT INTERVAL '4 5' DAY(3) TO HOUR FROM DUAL;
The output is:
+004 05:00:00
But i want to display output like
4DAYS 5HOURS
plz assist me how can we do this..
Thank you