[SOLVED] SQLite timestamp trigger syntax question (already written)

[Delaran]

create trigger purge_old_timestamp after insert on wantdb
begin
delete * from wantdb where timestamp > datetime('now', '-2 months')
end;

 

How do I get this statement to delete entries older than two months? Do I already have the syntax correct?

[Delaran]

oops, i realized this is the wrong forum.  Can I get this moved if any moderators have time?

 

Sorry! 

[Delaran]

Not that it matters here, but when/if this thread is moved the correct syntax was:

 

create trigger purge_old_entry after insert on wantdb
begin
delete from wantdb where timestamp = datetime('now', '-2 months');
end;