• 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.