[wp-trac] [WordPress Trac] #63662: DateTimePicker in the post editor does not show posts that are published on midnight of first day of month

[WordPress Trac]

#63662: DateTimePicker in the post editor does not show posts that are published on
midnight of first day of month
-------------------------------+-----------------------------
 Reporter:  butesa             |      Owner:  (none)
     Type:  defect (bug)       |     Status:  new
 Priority:  normal             |  Milestone:  Awaiting Review
Component:  Posts, Post Types  |    Version:  6.8
 Severity:  normal             |   Keywords:
  Focuses:                     |
-------------------------------+-----------------------------
 In the post editor, there is a date/time picker to select the publication
 time. Day with a publication are marked with a blue dot.

 The blue dot is missing if the post is scheduled for midnight of the first
 day of month.

 The SQL query that is executed by the REST API contains this condition:
 wp_posts.post_date < '2025-08-31 23:59:59' AND wp_posts.post_date >
 '2025-08-01 00:00:00'

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/63662>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform