Help with ORA-01830 error.
From: Steven Jackson <steven.jackson_at_matrikon.com>
Date: 23 Jan 2004 08:40:02 -0800
Message-ID: <ab12ac86.0401230840.6d2acfd6_at_posting.google.com>
Date: 23 Jan 2004 08:40:02 -0800
Message-ID: <ab12ac86.0401230840.6d2acfd6_at_posting.google.com>
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