Concat date and time in stored procedure

Soniad

Hello,

I am passing date and time individually to stored procedure as parameters as follows :

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

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

@ck9663
Here's part of Stored Procedure ,

Expand|Select|Wrap|Line Numbers

 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

@ck9663
Hello,

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

Expand|Select|Wrap|Line Numbers

 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"

Concat date and time in stored procedure

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ