Development Discussion Board

MySQL - http://dev.mysql.com/doc/refman/5.1/en/datetime.html MSSQL - http://msdn.microsoft.com/en-us/library/bb630352.aspx Oracle - http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005983 SQLite - http://www.sqlite.org/datatype3.html PostgreSQL - http://www.postgresql.org/docs...

They are. I have checked them all. This is the standard date format for all used DBMSs.

No. The sentences are not contradictory to each other.

For the moment the date is saved as VARCHAR 10 in the format of DD-MM-YYYY regardless of the server local. The date type field format is YYYY-MM-DD.

The date is formed by PHP function create_date or make_date (I don't remember exactly).

I don't know on MSSQL, but on MySQL/MariaDB its 0000 when there is error.

The PR I've submited works with all DBMS-es currently supported by phpBB ...

YYYY-MM-DD is the default supported format for dates for all DBMS-es supported by phpBB.

There is one more point in favour of date type field - there is support for date wothout year.

Related: https://area51.phpbb.com/phpBB/viewtopi ... 08&t=45879

I've started working on the date type.

Hello all, As I am in process of creating a PR for using Date type Data Base column for type_date custom profile filed, I was directed to put this RFC so we can discuss it. State now: Custom profile field type date uses for storage Varchar with length of 10 characters DB column. This allows board to...

I can do conversion only for the forum I administrate. But the date custom field is of type dd-mm-yyyy I think I is hardly defined.

Rofl ... that is a fair point ...

But you only get negative timestamp.

I can write a migration script ... Something along the lines of: Get all field names for type date For each of them do the following: Change name to some hash (so we don't duplicate it) Create new column with type int. Start converting old dates to unix timestamp and write them to the new column Dro...