Fetch Record ,Today,Future ,

What DataType do you use to have the Date in your table ?

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

hi,

If you have VARCHAR data type for input column, you can do as follows,

--Sample Data Generation
declare @tab table( dates varchaR(100))
insert @tab
SELECT '26.09.14' union all
SELECT '27.09.14' union all
SELECT '02.01.2015' union all
SELECT '25.02.2015' union all
SELECT '27.10.2015'

-- Query to be used
SELECT *, cast(dates as datetime) FROM @tab
where cast(dates as datetime) >= cast(getdate() as date)

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

If you want to add days based on today date then you must perform the dateadd function and add the required datatype as well as required days to be added for that.

select dateadd(d, 2,getdate());

The above query is give you todaydate+2 days.

select dateadd(m,2,getdate());

The above query is return todaydate+2 months.

select dateadd(y,2,getdate());

The above query is return todaydate+ 2 years.

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator