Hello,
I am passing date and time individually to stored procedure as parameters as follows :
- Exec mySP '01/31/2009' , '5:03:56 PM'
whithin this stored procedure, i have declared one variable (senddatetime varchar(50)) ,
i want to concat this date & time and want the date format value as
how to do this in stored procedure, i used many conversion ways, but no solutions.
Regards,
"D"