Herpington_McDerpington (12/3/2014)

---

Eirikur Eiriksson (12/3/2014)

---

Quick questions, what is the data source (ORA Version)? Have you tried using ALTER SESSION SET NLS_DATE_FORMAT to "format" the output of CURRENT_DATE? Don't think it's an ODBC issue as such, looks more like an incompatible date format issue.

😎

Thanks for the response Eirikur.

I'm honestly not sure how to see the ORA Version. I don't have the ability to do a whole lot over the ODBC connection. It's a Teradata ODBC connection and the version of that is 14.10.0304, though I don't think that's what you're looking for.

As far as the ALTER SESSION question goes - No, I've not tried that as I'm not at all familiar with that.

As an aside...I can query the DATA_WEST view directly with the following where clause:

WHERE (ID BETWEEN 1 AND 1000) AND (STARTDATE >= CURRENT_DATE - 1)

But if I use that same thing to query the view that includes data from multiple views, it once again throws an error for the DATA_WEST.STARTDATE_D column having an invalid date.