Use FND Value set FND_STANDARD_DATE
Procedure Code
PROCEDURE jkproc
(errbuf out varchar2,retcode out varchar2,p_processing_date in varchar2)
AS
v_date date ;
BEGIN
v_date:= fnd_date.canonical_to_date(p_processing_date);
END;
OR
Use
to_Date (substr(<date value>,1,10) ,'DD-MON-RRRR')
No comments:
Post a Comment