.Net Pickles

To find the previous date in SQL Server below query is used SELECT * FROM myTable WHERE C rDate < DATEADD ( d , - 1 , GetDate ()) The DATEADD ( d , - 1 , GetDate ()) function will subtract one from the current date and return the results In C#.Net we can do it using the below line of code DateTime .Now.AddDays(-1)

Syntax: <%= String.Format("{specifier}", DateTime.Now) %> Specifier Description Output d Short Date 8/4/2007 D Long Date 8-Apr-07 t Short Time 21:08 T Long Time 21:08:59 f Full date and time 4/8/2007 21:08 F Full date and time (long) 4/8/2007 21:08 g Default date and time 8/4/2007 21:08 G Default date and time (long) 8/4/2007 21:08 M Day / Month 8-Apr r RFC1123 date Sun, 08 Apr 2007 21:08:59 GMT s Sortable date/time 2007-04-08T21:08:59 u Universal time, local timezone 2007-04-08 21:08:59Z Y Month / Year Apr-07 dd Day 8 ddd Short Day Name Sun ...