Archives of the TeradataForum
Message Posted: Fri, 24 Apr 2015 @ 15:13:43 GMT
| Subj: || || Re: Subtracting two TIMESTAMP |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, April 24, 2015 09:07 -->
This could be completely off the mark, but have you done SHOW PROCEDURE to verify the SP code?
More than once I've had someone bring me their source SQL which looked fine, only to find that their SP had been compiled via ODBC with
DateTimeFormat=III so the actual SQL received / compiled by the database was different.