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.
https://www.ads-software.com/extend/plugins/exports-and-reports/
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Date field is adding hours’ is closed to new replies.