Title: Widget SQL NOW() function mismatch timezone
Last modified: January 10, 2020

---

# Widget SQL NOW() function mismatch timezone

 *  [juryiel](https://wordpress.org/support/users/juryiel/)
 * (@juryiel)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/widget-sql-now-function-mismatch-timezone/)
 * The widget uses the NOW() function in the query to find posts. Unfortunately,
   for whatever reason, the server time and the wordpress post time zones are not
   the same (and I can’t control the server timezone). This means posts that should
   appear don’t.
 * Can there be an option to add a timezone buffer e.g. compare to NOW() + 1 day,
   or some other alternative?

The topic ‘Widget SQL NOW() function mismatch timezone’ is closed to new replies.

 * ![](https://ps.w.org/wp-postratings/assets/icon.svg?rev=978014)
 * [WP-PostRatings](https://wordpress.org/plugins/wp-postratings/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-postratings/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-postratings/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-postratings/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-postratings/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-postratings/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [juryiel](https://wordpress.org/support/users/juryiel/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/widget-sql-now-function-mismatch-timezone/)
 * Status: not resolved