Re: Help with ORA-01830 error.

Steven Jackson wrote:
> Can anyone please help me with the cause of this error?
> ORA-01830: date format picture ends before converting entire input
> string
>
> I am performing the following statment in SQL+
> select count(*) from tableX where entry_date > '01-Jan-04 13.02.00';
> entry_date is a date field with the format dd-mon-rr however contains
> records with the HH.MM.SS format.
>
> In SQL+ I can use the to_date function however in the actual
> application that will not be possible or really useful for that
> matter.
>
> Can any give me some sugestions as to why the format does not seem to
> work or what can be done?
>
> Thanks in advance,
>
> Steven
> If possible please email me the reply so that I notice it faster.

where to_date( entry_date,'dd-mon-yy HH24.MI.SS') ...

-- 

Regards,
Frank van Bortel