[wp-trac] Re: [WordPress Trac] #2149: Historical Dates (Pre 1901) Unsupported in Wordpress

[WordPress Trac]

#2149: Historical Dates (Pre 1901) Unsupported in Wordpress
--------------------------------------+-------------------------------------
 Reporter:  wiseburn                  |        Owner:  pishmishy
     Type:  enhancement               |       Status:  assigned 
 Priority:  low                       |    Milestone:  2.6      
Component:  General                   |      Version:  1.5.2    
 Severity:  normal                    |   Resolution:           
 Keywords:  needs-patch dev-feedback  |  
--------------------------------------+-------------------------------------
Changes (by pishmishy):

  * keywords:  needs-patch => needs-patch dev-feedback

Comment:

 The range of dates covered by the 32-bit integer don't overlap with
 MySQL's ISO8601-like format. There's no easy way to reconcile this problem
 with PHP (unless we wish to write our own library for handling dates).
 What we could do is an SQL statement such as
 {{{
 mysql> select '1869-01-02 12:34:56' - INTERVAL 7 HOUR;
 +-----------------------------------------+
 | '1869-01-02 12:34:56' - INTERVAL 7 HOUR |
 +-----------------------------------------+
 | 1869-01-02 05:34:56                     |
 +-----------------------------------------+
 }}}
 I don't like adding unnecessary database queries but I think this is only
 going to get called when posts, pages or comments are created so it
 shouldn't cause too much overhead.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2149#comment:11>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software