All Forums Database
CCSlice 36 posts Joined 03/14
01 May 2014
SELECT Failed 2665: Invalid Date

Simply I am trying to return data between two date extremities.  The entity used is a timestamp and I have converted it to a date, but I this SELECT Failed 2665 error persists.  The only thing that I can think would cause this error would be the NULL values in some of the records.  Could that be the problem?  Is there an equivalent to the nz(Entity_name) in Access in Teradata?

                         CAST(A.LST_UPDT_TMSTMP AS DATE)
                         '01/01/2013'    -- REPORTING PERIOD START DATE
                         '01/01/2014'   -- REPORTING PERIOD END DATE 


tomnolan 594 posts Joined 01/08
01 May 2014

The error message is correct. Those are character literals that are not in a valid date format.
You should use DATE literals instead: BETWEEN DATE '2013-01-01' AND DATE '2014-01-01'

Qaisar Kiani 337 posts Joined 11/05
01 May 2014

I guess there is a UDF ISDATE(), which returns the valid date or null if it is invalid. You can use that to test the data in datecolumn you are working with.

You must sign in to leave a comment.