Dates in SQL / Changing Default Year.

[Jut]

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.

Code: Select all

1633032033 

Becomes :
2021-09-30 16:00

Code: Select all

1233032033

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

[atrol]

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

[Jut]

Thank you mate! I appreciate it!