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 ?
date_modified and last_modified wrong format
Moderators: Developer, Contributor
-
- Posts: 122
- Joined: 09 Mar 2016, 21:44
date_modified and last_modified wrong format
- Attachments
-
- php my admin.jpg (27.38 KiB) Viewed 11049 times
-
- mantis.jpg (10.72 KiB) Viewed 11049 times
-
- Access.jpg (9.3 KiB) Viewed 11049 times
Re: date_modified and last_modified wrong format
Why do you think this is in wrong format?NandoNaldo wrote:"date_modified" and "last_modified" column in my php my admin has a wrong format.
Dates are stored in Mantis as integers in Unix timestamp representation.
-
- Posts: 122
- Joined: 09 Mar 2016, 21:44
Re: date_modified and last_modified wrong format
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 (9.3 KiB) Viewed 11031 times
Re: date_modified and last_modified wrong format
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
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
-
- Posts: 122
- Joined: 09 Mar 2016, 21:44
Re: date_modified and last_modified wrong format
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 ?
-
- Posts: 122
- Joined: 09 Mar 2016, 21:44
Re: date_modified and last_modified wrong format
Hello Atrol,atrol wrote:Why do you think this is in wrong format?NandoNaldo wrote:"date_modified" and "last_modified" column in my php my admin has a wrong format.
Dates are stored in Mantis as integers in Unix timestamp representation.
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 (114.01 KiB) Viewed 11020 times
-
- Mantis 1.jpg (173.03 KiB) Viewed 11020 times