Required Data between two dates

[siddu]

I want to show the data between two dates.The date format is like this 2008-06-10 14:49:57.577

[Delerna]

check out the "between" statement in the help files

[shweta123]

Hi,

You can write sql query like this to get the records between 2 dates :

--Date variables
Declare @vdate1 varchar(50);
Declare @vdate2 varchar(50);


set @vdate1 = getdate(); --todays date
set @vdate2 = getdate()+100; -- date after 100 days

--Sql statement to compare 2 dates

SELECT * FROM Mytable
WHERE (CONVERT(varcha r,DateColumn,st yle) >= @vdate1 AND
CONVERT(varchar ,DateColumn,sty le) <= @vdate2)

In the above example , Convert function is used for converting the DateColumn value into required datetime format.

Hope this is what you require.