Hi,
In Oracle EBS i am registering a concurrent program where there is a need for a date parameter with time is needed. So i am using fnd_standard_datetime as the value set and i am using Default Type: SQL Statement and Default Value as below.
SELECT TO_DATE(TO_CHAR(MAX(process_date),'DD-MON-YYYY')||'22:59:59','DD-MON-YYYY HH24:MI:SS')
FROM table.
Above sql query is returning the value as 10/16/2020 10:59:59 PM.
Problem is the time 10:59:59 PM is not defaulting when trying to submit the concurrent program. The default value is displaying 16-OCT-2020 00:00:00.
How would i display the value as 16-OCT-2020 10:59:59 PM
OR
16-OCT-2020 22:59:59.
Please suggest what am i missing.
Appreciate your help.
Thank you
Ashok