WordPress.org

Ready to get started?Download WordPress

Forums

Exports and Reports
Date field is adding hours (2 posts)

  1. crlannen
    Member
    Posted 1 year ago #

    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/

  2. Scott Kingsley Clark
    Member
    Plugin Author

    Posted 1 year ago #

    What timezone is your WordPress site setup in? And what timezone is your WP Auctions plugin saving it's time in?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic