date_modified and last_modified wrong format

Post about your customizations to share with others.

Moderators: Contributor, Developer

date_modified and last_modified wrong format

Postby NandoNaldo » Jun 08, 2017 8:13 am

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 2047 times
mantis.jpg
mantis.jpg (10.72 KiB) Viewed 2047 times
Access.jpg
Access.jpg (9.3 KiB) Viewed 2047 times
NandoNaldo
 
Posts: 111
Joined: Mar 09, 2016 4:44 pm

Re: date_modified and last_modified wrong format

Postby atrol » Jun 09, 2017 7:01 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6712
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: date_modified and last_modified wrong format

Postby NandoNaldo » Jun 09, 2017 7:04 am

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 2029 times
NandoNaldo
 
Posts: 111
Joined: Mar 09, 2016 4:44 pm

Re: date_modified and last_modified wrong format

Postby atrol » Jun 09, 2017 7:09 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6712
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: date_modified and last_modified wrong format

Postby NandoNaldo » Jun 09, 2017 7:36 am

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 ?
NandoNaldo
 
Posts: 111
Joined: Mar 09, 2016 4:44 pm

Re: date_modified and last_modified wrong format

Postby atrol » Jun 09, 2017 8:10 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6712
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: date_modified and last_modified wrong format

Postby NandoNaldo » Jun 09, 2017 8:33 am

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 2018 times
Mantis 1.jpg
Mantis 1.jpg (173.03 KiB) Viewed 2018 times
NandoNaldo
 
Posts: 111
Joined: Mar 09, 2016 4:44 pm

Re: date_modified and last_modified wrong format

Postby atrol » Jun 09, 2017 9:09 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6712
Joined: Mar 26, 2008 4:37 pm
Location: Germany


Return to Customizations

Who is online

Users browsing this forum: Bing [Bot] and 9 guests