Solved

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

Posted on 2010-09-14
2
1,519 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
2 Comments
 
LVL 13

Accepted Solution

by:
riazpk earned 500 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Encryption Decryption in Oracle 12 108
Get the parent node - XMLTYPE 9 56
execute immediate plsql block 5 34
selective queries 7 22
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now