how to get the yest'day date in c#.net

Question

hello i want to get thedata from database yestday 6pm to today 6pm. how can i write code using c#.net and sql 2005 plz helpme...

Dipal Choksi · Answer

If you need to process the date the SQL2005 then you can use the DateAdd function of SQL Server.

Manish Dwivedi · Answer

Hi  U can do this by writing the stored procedure like that. declare @PreviousDate varchar(30) declare @CurrentDate varchar(30) set @PreviousDate = (select convert (varchar(30)getdate()-1101)+' 18:00:00.000' ) set @CurrentDate = (select convert (varchar(30)getdate()101)+' 18:00:00.000' ) select * from TableName where CreatedDate between @PreviousDate and @CurrentDate

Johnny GC · Answer

hi you can use the DateTime.Now().AddDays(-1) params to create a new DateTime like DateTime minus1day = DateTime.Now().AddDays(-1); minus1day = new DateTime(minus1day.Year minus1day.Month minus1day.Day 18 0 0); Johnny.