?
Solved

Oracle][ODBC Teradata Client driver][Teradata]Invalid operation on an ANSI Datetime or Interval value

Posted on 2010-09-14
2
Medium Priority
?
1,528 Views
Last Modified: 2013-11-11
using oracle gateway to access teradata; when I run this query:

SELECT   *
  FROM   "prodtab"."Claim"@datawarehouse
 WHERE   "pcyc" = '1658'
         AND "user_id" = '02249521'
         AND "Date_Pay" BETWEEN TO_DATE ('05/01/2009', 'mm/dd/yyyy')
                                     AND  TO_DATE ('06/30/2009',
                                                   'mm/dd/yyyy')

i get this error message

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC Teradata Client driver][Teradata]Invalid operation on an ANSI Datetime or Interval value.
ORA-02063: preceding 2 lines from DATAWAREHOUSE

please help
0
Comment
Question by:it-rex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
riazpk earned 2000 total points
ID: 33679966
What happens if you change:
AND "Date_Pay" BETWEEN
to:
AND cast("Date_Pay" as date) BETWEEN
?
0
 
LVL 11

Author Closing Comment

by:it-rex
ID: 33682636
great thanks
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question