Casting date & time to datetime in SQL

Casting & concatenating date & time field of a table to datetime & perform a datetime search query

Okey its a quick post.We will get date & time separably from C# & we will concatenating in DB as a datetime & perform a search query.


In C# to SQL 

Suppose  variable 1=11/9/2011 10:53:00 AM

V2=11/9/2011 12:42:50

In table we have two fields  like one is date & second is time  .Now we will cast them in to Datetime & search with datetime parameter of C#

--[sp_checkFlights]'11/9/2011 10:53:00 AM','11/9/2011 12:42:50'

ALTER PROCEDURE [dbo].[sp_checkFlights]

(

@gmtnow datetime,

@addedtime datetime

)

AS

BEGIN

SET NOCOUNT ON;

SELECT *

FROM tbl_sms_record

WHERE CONVERT(datetime, Convert(varchar, FlightDate) + ' ' + Convert(varchar(8), SchedularDepartureTime))

BETWEEN @gmtnow AND @addedtime

END