Archives of the TeradataForum

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

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

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>>