Reputation: 41
I have database in Azure. In column DeleteDate is date, when this row should be delete. How I can check and delete rows, which DeleteDate is today?
Upvotes: 1
Views: 78
Reputation: 59
Using TSQL you can: DELETE Table WHERE CONVERT(DATE,DeleteDate) = CONVERT(DATE,GETDATE())
Upvotes: 1