Concat date and time in stored procedure

[Soniad]

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

01/31/2009  5:03:56 PM

how to do this in stored procedure, i used many conversion ways, but no solutions.


Regards,
"D"

[ck9663]

How does your stored proc look like?

-- CK

[Soniad]

Concat date and time in stored procedure

How does your stored proc look like?

-- CK

Here's part of Stored Procedure ,

CREATE PROCEDURE dbo.SendMsg_proc           
        
@Gdate datetime,          
@GTime datetime,        


AS           
Begin 

Declare @DSentdttime as varchar(50)

set @DSentdttime = (select Convert(varchar,@Gdate,101) +' '+  Convert(varchar,@GTime,114))        

End

Regards,
"D"

[ck9663]

Pass it as varchar.

--CK

[Soniad]

Concat date and time in stored procedure

Pass it as varchar.

--CK

Hello,

I declared variable as varchar , and now its working .
Thank you.

CREATE PROCEDURE dbo.SendMsg_proc            
  
@Gdate  varchar(25),           
@GTime  varchar(25)              
  
  
AS            
Begin  
  
Declare @DSentdttime as varchar(50) 
  
set @DSentdttime = (select @Gdate +' '+ @GTime)         
  
End

Regards,
"D"