[wp-trac] [WordPress Trac] #48740: Add constant for database date format

[WordPress Trac]

#48740: Add constant for database date format
--------------------------------------+------------------------------
 Reporter:  Rarst                     |       Owner:  (none)
     Type:  enhancement               |      Status:  new
 Priority:  normal                    |   Milestone:  Awaiting Review
Component:  Date/Time                 |     Version:
 Severity:  normal                    |  Resolution:
 Keywords:  needs-patch dev-feedback  |     Focuses:
--------------------------------------+------------------------------

Comment (by remcotolsma):

 I have developed custom WordPress solutions that used `DATE` and
 `DATETIME(6)` types in custom database tables. I don't think WordPress is
 using these MySQL types currently. But the name `WP_DATE_MYSQL` could be
 confusing, for me it makes more sense that that constant contains the
 `'Y-m-d'` notation. Could be improved by using something like this:

 - `define( 'WP_DATE_MYSQL_DATE', 'Y-m-d' );`
 - `define( 'WP_DATE_MYSQL_DATETIME', 'Y-m-d H:i:s' );`
 - `define( 'WP_DATE_MYSQL_DATETIME_6', 'Y-m-d H:i:s.u' );`

 > but `WP_DATE_DATABASE` might be more appropriately generic.

 Maybe other database systems do accept a ISO 8601 date in queries?

 - https://dev.mysql.com/doc/refman/8.0/en/datetime.html
 - https://github.com/php/php-src/pull/3690

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/48740#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform