Mantis Bug Tracker - Forums

Does anyone know how Mantis saves the dates in sql ? Because the string is pretty illogical to me.
I am looking to change the year of previous bugs and I am stumped. Becomes :
2021-09-30 16:00 Becomes
2009-01-26 23:53


Side note, does anyone have an idea on how to override the default (actual year) and replace this with lets say 2021?

I use version 2.25.2 mantis
10.3.35-MariaDB-cll-lve
hosted on linux

Dates are stored as integer Unix timestamp https://en.wikipedia.org/wiki/Unix_time

Thank you mate! I appreciate it!