Loading

how to compare given date and 1 day than current date

ramakotaiah patti

9y845SQL

i am create a table with 4 fields with id 1st collumn as auto generated,name 2nd column,fromdate 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 ....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
INSERT INTO [TableName]([Name], [FromDate], [ToDate]) VALUES('abc', CONVERT(nvarchar(11),[FromDate],103 ),CONVERT(nvarchar(11),DATEADD(day,-1, GETDATE()),103 ))
+1
Manas Mohapatra9y ago
Try with below query:
INSERT INTO tblName(Name, FromDate, ToDate) VALUES('Patti', '2013-04-01', DATEADD(day,-1, GETDATE());
+1
Midhun Tp9y ago
Hi,

Try below query -

SELECT dateadd(dd,-1,getdate()) as yesterday_date

+1