
April 29th, 2012, 08:09 PM
|
|
Contributing User
|
|
Join Date: Jan 2006
Location: Carlsbad, CA
|
|
I do not know if it helps but (no database involved):
This works for me.
Code:
begin
-- Test statements here
dbms_output.put_line('start: ');
dbms_output.put_line(TO_DATE( TO_CHAR ( to_date('10-AUG-1951'), 'dd/mm') || '/1921', 'dd/mm/yyyy'));
dbms_output.put_line('date: ');
end;
Output was
start:
10-AUG-21
date:
Are you sure all your source dates are valid?
|