Page 1 of 1

Manipulate submission date

Posted: 12 Jan 2017, 01:01
by TheOuterLinux
Is there a way to change the submission date of a bug? phpMyAdmin? I've looked at my database stuff, but the date_submitted column in mantis_bug_table looks like secret code and not readable by humans. Problem is, I got a few submissions I'd like to add to my project, but the discovery dates are in the past and it would look like a bunch just happened to of popped up all of a sudden, which isn't true. I've even solved most of them, but I'd like a professional looking record of it.

Re: Manipulate submission date

Posted: 12 Jan 2017, 09:16
by atrol
This is the format we store the date
http://dev.mysql.com/doc/refman/5.7/en/ ... -timestamp

Re: Manipulate submission date

Posted: 12 Jan 2017, 19:15
by TheOuterLinux
Thank you so much the reply; it helped a whole lot :). Also, I found a website that converts Unix timestamps if anyone else sees this post and has the same issue: http://www.unixtimestamp.com/index.php