I need some help with this SQL statment.
I would like to set up and automated task so that it will delete archived messages older that 60 days. I am running openfire 3.6.2 and SQL Express 2008.
I have tried a few different statments like the following.
select * FROM ofMessageArchive
where sentdate > (CURRENT_TIMESTAMP-5184000)
If any one could help me figure this out, it would be greatly appreciated.
Thanks
Kris