By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

Help with ORA-01830 error.

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.