Mantis Bug Tracker - Forums

Hello,

I noticed that "date_modified" and "last_modified" column in my php my admin has a wrong format. Also i have configured Mantis with ODBC so i can do some querry throught Access.
Even here, in access the "date_modified" and "last_modified" column had wrong date format ( attach below)

Any help please ?

NandoNaldo wrote:"date_modified" and "last_modified" column in my php my admin has a wrong format.

Why do you think this is in wrong format?
Dates are stored in Mantis as integers in Unix timestamp representation.

Actually the wrong format is on the access file. After connecting dhe DB of Mantis with ODBC with Access, when i do the querry the format date is wrong: for ex: 21/02/1472

I don't use Access, so I can't help you.
I would expect that Access displays just the same integer numbers that you see in phpMyAdmin.
Access and any other database client can't know that there are dates stored, so you have to tell those clients how to display the numbers as a readable date string.
Might help: https://www.access-programmers.co.uk/fo ... hp?t=70481

Is it possible to add date_modified filed into the All Available Columns - CSV Columns so i can donwload reports in CSV format and filter info from the CSV file regarding the date_modified ?

Check page My Account > Manage Columns
The name of the column you have to add is "last_updated"

atrol wrote:

NandoNaldo wrote:"date_modified" and "last_modified" column in my php my admin has a wrong format.

Why do you think this is in wrong format?
Dates are stored in Mantis as integers in Unix timestamp representation.

Hello Atrol,

I was looking my diffrent php mantis tables ( since i have two diffrent one). At the first the date_modified is diffrent.

You looked at the database of two different Mantis versions.
The format has changed to integer since version 1.2.