[wp-trac] [WordPress Trac] #48006: post_date no as expected

[WordPress Trac]

#48006: post_date no as expected
--------------------------+-----------------------------
 Reporter:  marrank       |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  5.2.3
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I have noticed this when scheduling a post.

 1) From wp-admin choose Pages.
 2) Add new.
 3) Change from publish immediately to selecting time and date.
 4) Select a date, for example, 2019-09-09 17:00
 5) Save the post.
 6) Look in the wp_posts table in the database for the post and the
 post_date column will be something like 2019-09-09 17:00:21

 It is not really as expected since you, as a user, are not able to set
 which second the page should be published you assume it would be at 00. In
 this case you expect that is is 17:00:00. The problem is that if you have
 a scheduled crontab that runs every 5 minutes (*/5) it will get missed
 schedule the first time since the cron will run at 17:00:00 and the
 publish time of the post is 17:00:21. From my experience most users choose
 the schedule at top of the hour so we get this missmatch a lot. For us it
 would be easier if assumed that it is 00 seconds always.

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