Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Teradata BTEQ - Invalid timestamp issue
 
From:   Koushik Chandra

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020