SELECT GetDate()-1 AS Yesterday, Field2, Field3 FROM table1
Select dateadd(d,-1,GETDATE())
MyTable: ID ... BigInt Title ... NvarChar(50) Date ... DateTime
Select ID, Title, (select [Date] Where [Date]>='2012-06-20') as Date from MyTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)