how to compare given date and 1 day than current date

Question

i am create a table with 4 fields with id 1st collumn as auto generatedname 2nd columnfromdate 3rd column and todate 4th column..date fill 1st 3 columns manually and but 4 th column as not filled it will come by executing time based on currrent date and it must less than one day(today)....how i will get using sql query ....

Rafnas T P · Answer

INSERT INTO [ TableName ]([ Name ] [ FromDate ] [ ToDate ]) VALUES(' abc ' CONVERT(nvarchar(11)[ FromDate ]103 )CONVERT(nvarchar(11)DATEADD(day-1 GETDATE())103 ))

Manas Mohapatra · Answer

Try with below query: INSERT INTO tblName(Name FromDate ToDate) VALUES( 'Patti'  '2013-04-01'  DATEADD(day-1 GETDATE());

Midhun T P · Answer

Hi Try below query - SELECT dateadd(dd-1getdate()) as yesterday_date