?
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,526 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

762 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