Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-error 01858 in asp.net query

Status
Not open for further replies.
Mar 14, 2002
711
US
I keep seeing this error when I run this query and I know the error points to this part of the query:

AND TO_DATE(EQ_EVENTS.EVENT_END_DATE, 'MM/DD/YYYY') = TO_DATE(SYSDATE-24 , 'MM/DD/YYYY')

This is the complete error:

ORA-01858: a non-numeric character was found where a numeric was expected

I checked the database and all dates in this column are listed as 3/27/2006 etc, etc.

What am I missing here?

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top