Title: Date field is adding hours
Last modified: August 21, 2016

---

# Date field is adding hours

 *  [crlannen](https://wordpress.org/support/users/crlannen/)
 * (@crlannen)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/date-field-is-adding-hours/)
 * For some reason 4 hours is being added to just one of the date (date_start) fields
   output.
 * This is my query:
 *     ```
       SELECT wpsilentauction_posts.ID,
       wpsilentauction_posts.post_title,
       wpsilentauction_posts.post_type,
       wpsilentauction_wpa_auctions.id,
       wpsilentauction_wpa_auctions.date_start,
       wpsilentauction_wpa_auctions.date_end,
       wpsilentauction_wpa_auctions.customincrement AS Increment,
       wpsilentauction_wpa_auctions.start_price,
       wpsilentauction_wpa_bids.id
       FROM (wpsilentauction_posts INNER JOIN wpsilentauction_wpa_auctions ON wpsilentauction_posts.post_title = wpsilentauction_wpa_auctions.name) INNER JOIN wpsilentauction_wpa_bids ON wpsilentauction_wpa_auctions.id = wpsilentauction_wpa_bids.id
       WHERE (((wpsilentauction_posts.post_type)='post'))
       ORDER BY wpsilentauction_wpa_auctions.id
       ```
   
 * The correct time is displaying in the Auctions admin for each of the auction 
   items.
 * [http://wordpress.org/extend/plugins/exports-and-reports/](http://wordpress.org/extend/plugins/exports-and-reports/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/date-field-is-adding-hours/#post-3927339)
 * What timezone is your WordPress site setup in? And what timezone is your WP Auctions
   plugin saving it’s time in?

Viewing 1 replies (of 1 total)

The topic ‘Date field is adding hours’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

## Tags

 * [date](https://wordpress.org/support/topic-tag/date/)
 * [reports](https://wordpress.org/support/topic-tag/reports/)
 * [time](https://wordpress.org/support/topic-tag/time/)

 * 1 reply
 * 2 participants
 * Last reply from: [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/date-field-is-adding-hours/#post-3927339)
 * Status: not a support question