[wp-trac] [WordPress Trac] #8885: get_posts() should default orderby post_date_gmt

WordPress Trac wp-trac at lists.automattic.com
Fri Jan 28 04:18:00 UTC 2011


#8885: get_posts() should default orderby post_date_gmt
-------------------------------------+-----------------------------
 Reporter:  caorongjin               |       Owner:  anonymous
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Optimization             |     Version:  2.7
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |
-------------------------------------+-----------------------------
Changes (by solarissmoke):

 * keywords:  needs-patch => has-patch needs-testing


Comment:

 Replying to [comment:18 Denis-de-Bernardy]:
 > post_date_gmt should contain the UTC time without any daylight savings
 or other adjustments. The raw stuff.

 That's precisely what it is in the database for - so that we have a
 universally fixed timestamp to compare things with, separately from
 `post_date` which contains daylight savings adjustments.

 GMT === UTC for all practical purposes. See
 http://en.wikipedia.org/wiki/Coordinated_Universal_Time.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/8885#comment:20>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list