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

Try

where trunc(sysdate) = trunc(to_date(:localDateField, 'DD-MON-YYYY hh24:MI:SS'));

/JhMa
Mirza Mohsin Beg <mbeg_at_netearnings.com> wrote in message news:37574B22.657CE810_at_netearnings.com...
>
>
> 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 Fri Jun 04 1999 - 09:49:08 CDT