After 24 hours it disappears to forum members, but it’s still visible to moderators and back-end staff
What I found from Discourse about comments:
For the Author: If a user deletes their own post, it is often kept hidden in a “trash can” or “grace period” (configurable by the admin, usually up to 24 hours). During this time, the author can view the post (often indicated by a “(post deleted by author)” message) and restore it.
For Moderators & Admins: Once the user’s grace period expires, the comment becomes fully hidden from regular users but remains visible to staff members (highlighted in orange) indefinitely, unless it is manually and permanently hard-deleted from the database.
Database Backups: Even if an administrator uses the hidden permanent deletion feature to wipe the comment from the live interface, it will remain in forum backups for up to 30 days.
I’ve taken a wand to the highest peak in the Lake District (not that you needed or wanted to know LOL) but a holiday isn’t a holiday without taking a few items