Monday, May 24, 2010

Date Btween Date Range check

select top 500 convert(datetime,LastUpdated_Date,101),* from contactDetails
where convert(datetime,LastUpdated_Date,101) between convert(datetime,'Apr 01, 2009',101) and convert(datetime,'May 31, 2010',101)

No comments:

Post a Comment