Help with ORA-01830 error.

[Steven Jackson]

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.

[Frank van Bortel]

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