I would like to use standard database function TO_CHAR() in order to format TIMESTAMP(6) field in date format only. I want to execute the query below:
SELECT WAREHOUSE, SSCC, MATERIAL, QUANTITY, TO_CHAR( EXPIRYDATE ,'YYYY-MM-DD'), STOCK_STA FROM SAPSTOCKREPORTITEM;
After research I found the note 2072891 2072891 - How-to use database standard functions in query to database using Receiver Communication Channel where are mentioned two attributes hasQuot and metadata. I followed the steps but I did't succeed.
My systems are PO 7.4 Java stack only and Oracle 11g.
Has anyone succeed to use the function TO_CHAR?