Dates in SQL / Changing Default Year.

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Jut
Posts: 9
Joined: 29 Oct 2021, 04:21

Dates in SQL / Changing Default Year.

Post by 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
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Dates in SQL / Changing Default Year.

Post by atrol »

Dates are stored as integer Unix timestamp https://en.wikipedia.org/wiki/Unix_time
Please use Search before posting and read the Manual
Jut
Posts: 9
Joined: 29 Oct 2021, 04:21

Re: Dates in SQL / Changing Default Year.

Post by Jut »

Thank you mate! I appreciate it!
Post Reply