Tuesday, 3 September 2013

sqlce select rows that are older than 1 month

sqlce select rows that are older than 1 month

How can I delete the rows that are older than 1 month?I found this sql
statement from google but doesnt work. what is the right way to do it?
select * from L_TAHSILAT where creation_date <= dateadd(mm ,-1,getdate())

No comments:

Post a Comment