Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Problem Regarding DATE FORM using SP

Author  Topic 

kamalkishore_in
Yak Posting Veteran

76 Posts

Posted - 2001-04-23 : 01:39:13
Hello Gurus,

May it would be very simple for you guys....

I am passing a date to a stored procedure in yy/mm/dd format.
Like spName '02/01/03'

but when I am printing that variable using stored procedure like

print @dt it prints
01 3 2002 12:00AM

I mean dd mm yyyy.

Why it is so.... and what is the command to get the date in yy/mm/dd format within the Stored procedure.

Thanks and waiting for your help


   

- Advertisement -