Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Dec 2003 @ 11:29:48 GMT


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


Subj:   Re: Store Procedure Error 2665
 
From:   Victor Sokovin

Thanks for posting the parameters. I notice that although the Current Date Form is ANSIDate, the Default Date Format looks more like the default for the IntegerDate mode: YY/MM/DD. With the ANSIDate mode I would rather expect 'YYYY-MM-DD'.

I think this short ('YY') format is used by the DATE variables in the stored procedure, and it causes problems when 'YYYY' values are being assigned to the variables. I would expect to see the same bahaviour on the Unix system as well if the date settings there are exactly identical. Anyway, I would look into the Default Date Format and change it to 'YYYY-MM-DD', if appropriate on your system.


Regards,

Victor



     
  <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: 23 Jun 2019