Home/Questions/Q 5548
In Process
Richmond
Richmond

Richmond

View Profile
  • 1
Contributor
Asked: 2021-02-23T14:41:34+05:30

HOW TO CONVERT STRINGS TO DATE

  • 1

Can you help me out on this code and logic
I WANT TO CONVERT THIS 5/24/2021 TO 5/24/2021 AFTER PERFOMING DYNAMIC ACTION.

declare

m_date date;
duration number;

begin
number := 91;
SELECT to_date(:P35_DATE_OF_INVESTMENT)  +  duration into m_date FROM dual;

return to_date(trunc(m_date),'mm/dd/yyyy');

end;

maturity date = date of investment + duration.
i want to get the date in these format 5/24/2021 not these 5/24/2021 .

Thanks

date

    4 Answers

    1. Vinish

      Vinish

      View Profile
      Legendary

      For the Oracle Apex date item, you need to convert it to date with the date format. I am assuming that you are already displaying the date in the mm/dd/yyyy (05/25/2021) format. Below is the example:

      declare
m_date date;
duration number;
begin
duration := 91;
SELECT to_date(:P35_DATE_OF_INVESTMENT, 'mm/dd/yyyy')  +  duration
 into m_date FROM dual;
return trunc(m_date);
end;

       

      • 0

    You must login to add an answer.