Help: To_date() problem in Pro*C ??

I have the following code (with NLS_DATE_FORMAT set as 'DD-MON-YYYY' in init.ora)

{
exec sql begin declare section
localDateField char[25] = "03-JUN-1999 12:24:34"; localSelectField char[5] = "";
exec sql end declare section

exec sql
select 'x' into :localSelectField
from dual
where trunc(sysdate) = to_date(:localDateField, 'DD-MON-YYYY');

}

This gives me
Ora-01830: date format picture ends before converting entire input string.
What is going on ? What am I doing wrong?

Thanks,

-M
ps: please email me directly also Received on Thu Jun 03 1999 - 22:42:26 CDT