Archives of the TeradataForum

Message Posted: Mon, 31 Jan 2005 @ 13:28:07 GMT

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

Hi All,

My problem is that when I define Date as an Input Parameter for a Stored Procedure, the format taken is 'yy/mm/dd'. My system Dateform is set as ANSI ( YYYY-MM-DD) as a DBS CONTROL parameter.

How can I set the Input Date Parameter as ( YYYY-MM-DD) instead of 'YY/MM/DD'

Any thoughts / experiences.

Sample Code:

     REPLACE PROCEDURE procname.( IN CR_DATE DATE)
     BEGIN
     END;

Thanks in Advance,

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