Skip to Content
0
Former Member
Feb 05, 2016 at 12:08 PM

Standard database function TO_CHAR() usage

1065 Views

Dear Experts,

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?

Best regards,

Rossitsa