Sunday, December 23, 2007

STRING_TO_DATE

For the concurrent request parameters, if you are sending a VARCHAR2 type of parameter as a date variable, I would suggest to use STRING_TO_DATE function for conversion; See below;

g_DateUB := NVL(Fnd_Conc_Date.STRING_TO_DATE (p_dateUB), SYSDATE);

0 comments: