Archives of the TeradataForum
Message Posted: Mon, 31 Jan 2005 @ 13:28:07 GMT
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.
REPLACE PROCEDURE procname.( IN CR_DATE DATE) BEGIN END;
Thanks in Advance,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|