Archives of the TeradataForum

Message Posted: Sat, 05 Nov 2016 @ 09:23:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I am trying to execute an sql through TERADATA BTEQ and getting the below error.

But the same sql is running good when getting executed in Teradata SQL assistant.

     WHERE S_ORDER_ITEM.LAST_UPD ?BETWEEN CAST( (('20050614' (DATE, FORMAT
     'YYYY-MM-DD')) -1 (CHAR(10)) )|| ' ' || '22:00:01' AS TIMESTAMP(0)) ?AND CAST(
     (('20050614' (DATE, FORMAT 'YYYY-MM-DD')) (CHAR(10)) )|| ' ' || '22:00:00' AS
     TIMESTAMP(0) )
     *** Failure 2666 Invalid date supplied for S_ORDER_ITEM.LAST_UPD.

Regards,

Koushik Chandra

	<Prev	Next>		<<First	<Prev	Next>	Last>>