• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1531
  • Last Modified:

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

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
it-rex
Asked:
it-rex
1 Solution
 
riazpkCommented:
What happens if you change:
AND "Date_Pay" BETWEEN
to:
AND cast("Date_Pay" as date) BETWEEN
?
0
 
it-rexAuthor Commented:
great thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now