Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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