Canonical Date Function

passing character from parameter - fnd_standard_date

select fnd_date.canonical_to_date('2008/01/12') from dual;

alternate solution :

lv_start_date := TRUNC(TO_DATE(p_start_date,'YYYY/MM/DD HH24:MI:SS'))