Manipulate submission date

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
TheOuterLinux
Posts: 2
Joined: 12 Jan 2017, 00:48

Manipulate submission date

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

Re: Manipulate submission date

Post by atrol »

This is the format we store the date
http://dev.mysql.com/doc/refman/5.7/en/ ... -timestamp
Please use Search before posting and read the Manual
TheOuterLinux
Posts: 2
Joined: 12 Jan 2017, 00:48

Re: Manipulate submission date

Post 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
Post Reply