I have a stored procedure that takes varchar parameter. I convert this to date with the following function, how can I add default time to it.
open_date is a varchar2 , how can I add time to it .
Open_Date = to_date(p_BM_Open_Date, 'mm/dd/yyyy')
eg: instead of 6/21/2006 it should update the table with 6/21/2006 4:05:10 PM