MantisBT - Database Support

[paul]

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul

[Angel Celaya]

Hi, I'm new Mantis user. I've a question about databse dates format meaning. For example on mantis_bug_history_table, the column "date_modified" has value 1371224553
How can I represent it on ddmmyyyy format?
Thanks for your help!

[paul]

Hi Angel,

I hope you like Mantis. In terms of your question, we store dates as unsigned int's / seconds from 1980 - hence the value of 1371224553 you describe. The PHP Date function can be used to format the value: See http://uk3.php.net/manual/en/function.date.php

So for example: date( "dmY", 1371224553 ) I believe would give the output you are looking for.

Paul

[paul]

.