Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2005 @ 14:55:53 GMT

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

Hi Kumar_Hare:

I just realized something that I had considered in my first reply to your post. It is not the DATEFORM when the stored procedure is called that matters. It is the DATEFORM used when the stored procedure is CREATEd that matters.

I did the following to test:

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

     With:  CALL dater(1050130);

     It returned:   05/01/30

Then I did this:

     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:   2005-01-30

I hope this helps you.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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