teradata -datastage date Prob

Sreedhar · Post by **Sreedhar** » Fri Jan 28, 2011 3:02 am

Hello,

Here is my query.
When I run this in Teradata SQL Assistance I get the results.
select count(*) from lci_loyal_views.sywr_enrollment_exclusions where TRS_DT >= '2010-12-01' and TRS_DT <= '2010-12-31'

When I put the same query in datastage using a ODBC stage I am getting zero records.

can someone help me here....

richdhan · Post by **richdhan** » Mon Jan 31, 2011 6:04 am

Hi,

Are you using the same credentials for both Teradata SQL Assistant and the ODBC stage? Did you try with any other Teradata stage other than the ODBC stage?

--Rich