Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2005 @ 15:51:41 GMT


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


Subj:   Re: DATE Format of INPUT Parameter for STORED PROCEDURE
 
From:   Kumar_Hare

Hi Michael,

Thanks a lot for the information. It is really very helpful.

But there is something strange happing on my box.

I run the code sent by you ie.

     SET SESSION DATEFORM=ANSIDATE;
     replace procedure dater (in indate date, out outdate char(10))
     begin
     set outdate = indate;
     end;

     With:  CALL dater(1050130);

     It returned error: 3812: The Positional assignment list has too few values.

Am I really missing something.

Secondly when I see the structure for dater

it looks like:

     Name                Type        Length        Format        In/Out
     indate        DATE        4                YY/MM/DD        In
     outdate        CHAR        10                X(10)                Out

Why the indate format is 'YY/MM/DD' and not 'YYYY-MM-DD'


Thanks,



     
  <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: 28 Jun 2020