Parameter Passing

[asth01]

Hi,

There is a date parameter that is passed in a procedure.
The procedure is run externally from TOAD and a value of '12-MAR-1901' is provided. When it runs, it takes up
'12-MAR-01' which is treated as '12-MAR-2001'.

How can I prevent this ?

Thanks in advance.

Any help is appreciated....

 

[carp]

You might try passing in
TO_DATE('12-MAR-1901','DD-MON-YYYY')

Elbert, CO
1624 MST