Search found 23 matches

by Lucifer4o
Sat Aug 02, 2014 9:01 am
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

Re: [RFC] use date type DBMS field for type_date custom profile fields

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...
by Lucifer4o
Fri Aug 01, 2014 7:46 pm
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

Re: [RFC] use date type DBMS field for type_date custom profile fields

They are. I have checked them all. This is the standard date format for all used DBMSs.
by Lucifer4o
Thu Jul 31, 2014 8:42 pm
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

Re: [RFC] use date type DBMS field for type_date custom profile fields

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).
by Lucifer4o
Wed Jul 30, 2014 7:08 am
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

Re: [RFC] use date type DBMS field for type_date custom profile fields

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 ...
by Lucifer4o
Thu Jul 24, 2014 12:36 pm
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

Re: [RFC] use date type DBMS field for type_date custom profile fields

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.
by Lucifer4o
Mon Jul 07, 2014 8:58 am
Forum: [3.x][Archive] RFCs
Topic: [RFC] use date type DBMS field for type_date custom profile fields
Replies: 9
Views: 26704

[RFC] use date type DBMS field for type_date custom profile fields

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...
by Lucifer4o
Thu Apr 24, 2014 4:43 pm
Forum: [3.x][Archive] RFCs
Topic: Refactoring user search to allow search/filter by custom fields
Replies: 21
Views: 43603

Re: Refactoring user search to allow search/filter by custom fields

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.
by Lucifer4o
Thu Apr 24, 2014 10:23 am
Forum: [3.x][Archive] RFCs
Topic: Refactoring user search to allow search/filter by custom fields
Replies: 21
Views: 43603

Re: Refactoring user search to allow search/filter by custom fields

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

But you only get negative timestamp.
by Lucifer4o
Wed Apr 23, 2014 5:08 am
Forum: [3.x][Archive] RFCs
Topic: Refactoring user search to allow search/filter by custom fields
Replies: 21
Views: 43603

Re: Refactoring user search to allow search/filter by custom fields

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...