date_modified and last_modified wrong format

Post about your customizations to share with others.

Moderators: Developer, Contributor

Post Reply
NandoNaldo
Posts: 122
Joined: 09 Mar 2016, 21:44

date_modified and last_modified wrong format

Post by NandoNaldo »

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 ?
Attachments
php my admin.jpg
php my admin.jpg (27.38 KiB) Viewed 10980 times
mantis.jpg
mantis.jpg (10.72 KiB) Viewed 10980 times
Access.jpg
Access.jpg (9.3 KiB) Viewed 10980 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: date_modified and last_modified wrong format

Post by atrol »

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.
Please use Search before posting and read the Manual
NandoNaldo
Posts: 122
Joined: 09 Mar 2016, 21:44

Re: date_modified and last_modified wrong format

Post by NandoNaldo »

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
Attachments
Access.jpg
Access.jpg (9.3 KiB) Viewed 10962 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: date_modified and last_modified wrong format

Post by atrol »

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
Please use Search before posting and read the Manual
NandoNaldo
Posts: 122
Joined: 09 Mar 2016, 21:44

Re: date_modified and last_modified wrong format

Post by NandoNaldo »

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

Re: date_modified and last_modified wrong format

Post by atrol »

Check page My Account > Manage Columns
The name of the column you have to add is "last_updated"
Please use Search before posting and read the Manual
NandoNaldo
Posts: 122
Joined: 09 Mar 2016, 21:44

Re: date_modified and last_modified wrong format

Post by NandoNaldo »

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.
Attachments
mantis 2.jpg
mantis 2.jpg (114.01 KiB) Viewed 10951 times
Mantis 1.jpg
Mantis 1.jpg (173.03 KiB) Viewed 10951 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: date_modified and last_modified wrong format

Post by atrol »

You looked at the database of two different Mantis versions.
The format has changed to integer since version 1.2.
Please use Search before posting and read the Manual
Post Reply