I have a SP like this
replace procedure temp(in indate date,out temp varchar(100))
when i execute this SP, i am getting the date with year part contalining only two digits.
I am not facing any issues when i set the session and replace the proc and run.
But is there any way we can handle it inside the proc?