[wp-trac] [WordPress Trac] #41782: Using date_query with 'before' in WP_Query returns wrong timezone

[WordPress Trac]

#41782: Using date_query with 'before' in WP_Query returns wrong timezone
--------------------------+------------------------------
 Reporter:  Biranit       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Date/Time     |     Version:  4.8.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by jave.web):

 There is also another issue in this part:


 {{{
 DATE_FORMAT( POST_DATE, '%H.%i%s' ) <= CALCULATED
 }}}

 Because for e.g. {{{'2018-11-05 20:56:00'}}} it will produce something
 like

 {{{
 20.5600 <= 8.274500
 }}}

 Therefore, you would only get posts or whatever only in a part of the
 day...

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