[wp-trac] [WordPress Trac] #18694: Improved date arguments for WP_Query

[WordPress Trac]

#18694: Improved date arguments for WP_Query
--------------------------+------------------------------
 Reporter:  Viper007Bond  |       Owner:  viper007bond
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:  3.3
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------

Comment (by Viper007Bond):

 Oh, and here's the SQL of the above examples:

 ` AND ( ( DATE_FORMAT( wp_trunk_posts.post_date, '%H.%i' ) >= 8.450000 )
 AND ( DATE_FORMAT( wp_trunk_posts.post_date, '%H.%i' ) <= 17.120000 ) AND
 ( DAYOFWEEK( wp_trunk_posts.post_date ) BETWEEN 2 AND 6 ) )`

 ` AND ( ( wp_trunk_posts.post_date > '2011-09-05 01:44:13' AND
 wp_trunk_posts.post_date < '2011-09-12 01:44:13' ) )`

 ` AND ( ( wp_trunk_posts.post_date < '2010-03-01 00:00:00' ) )`

 ` AND ( ( HOUR( wp_trunk_posts.post_date ) = 14 ) OR ( DAYOFWEEK(
 wp_trunk_posts.post_date ) IN (1,2) AND HOUR( wp_trunk_posts.post_date )
 IN (18) ) )`

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