| ORA-01858 Error [message #59438] |
Wed, 19 November 2003 20:57  |
Susan
Messages: 102
Registered: October 2001
|
Senior Member |
|
|
Hi,
Actually i am facing some problem .
select
months_between(to_date(dateofjoin,'dd/mm/yyyy'),to_date(to_char('1/4/2003','dd/mm/yyyy'),'dd/mm/yyyy')) as datedifference from
salary.emp_detail is working perfect but
select * from salary.emp_detail where
months_between(to_date(dateofjoin,'dd/mm/yyyy'),to_date('1/4/2003','dd/mm/yyyy'))>1
is showing
ORA-01858 a non-numeric character found where a digit was expected
error.Can u help me
Best regards.
Susan
|
|
|
|
| Re: ORA-01858 Error [message #59479 is a reply to message #59438] |
Tue, 25 November 2003 07:37  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
The specified date literal is wrong. Try to change:
-> to_date('1/4/2003','dd/mm/yyyy')
to
-> to_date('01/04/2003','dd/mm/yyyy')
Best regards.
Frank Naude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
