Take a look at meta.php:777: … CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$meta_compare_string})… So if you want to use DATE comparisons, you should use MySQL compatible date formats (YYYY-MM-DD). Change this part of your code: array( ‘key’ => ‘date’, ‘value’ => date(“Y/m/d”), ‘compare’ => ‘>=’, ‘type’ => ‘DATE’ ), to: array( ‘key’ => ‘date’, ‘value’ => date(“Y-m-d”), … Read more
WordPress already have such function in its core. It’s called ‘human_time_diff’ and it’s used in WP admin section. Usage is pretty simple: echo human_time_diff( $from, $to ); where $from is Unix timestamp from which the difference begins and $to is Unix timestamp to end the time difference (or time() by default). So you’ll have to … Read more
Summary: WordPress does run date_default_timezone_set( ‘UTC’ );. It does have a timezone option modifiable by the admins and retrieved using get_option( ‘timezone_string’ ). However, none of that has any effect on the query run through $wpdb. You should get the same results from $wpdb as if you had run the MySQL query without WordPress. Details … Read more
You need to be storing your dates in some sortable format such as YYYY-MM-DD, or as a unix timestamp, otherwise you can’t do this just with a query. Once it’s in the format YYYY-MM-DD this should work. try this: function concerts_pre_get_posts( $query ) { if ( !is_admin() ) return; if ( isset( $query->query_vars[ ‘post_type’ ] … Read more
Second try: 😉 pre_get_posts runs AFTER parse_query(). parse_query() transforms ‘meta_key’ etc. into ‘meta_query’. get_posts() doesn’t seem to react on ‘meta_key’ etc. directly. So try adding $query->parse_query() after your $query->set() calls or use filter that runs before parse_query (edited, the parse_query() filter doesn’t work, either – it runs too late). Edit: to do the switch: function … Read more
Post date/time can’t be changed via the Quick-Edit bulk editor. You might edit the SQL directly, if you’re comfortable running a query in PHPMyAdmin. Or, you could search for a Plugin?
$args = array( ‘post_status’ => “future”, ‘order_by’ => ‘date’, ‘order’ => ‘ASC’ ); $yourLoop = new WP_Query($args);
but when I visit a month with no posts my template returns the date “January 1970” instead. Yes. That will happen. UNIXTIME began on Jan 1, 1970. That is “0000/00/00” but negative numbers work back until sometime in 1901. strtotime will return false for anything outside that range, including your nonexistent dates. date will assume … Read more
WordPress uses GMT. The only way to get around that is to declare a new timezone after the header to use for your own purposes. Kind of a pain. Also see this answer: How to get WordPress Time Zone setting?
Just use date_i18n in multiple places with PHP date arguments just for what you need: if ( $date = get_post_meta( $thepostid, ‘_sale_price_dates_to’, true ) ) { $sale_price_dates_to = ‘<span class=”m”>’ . date_i18n( ‘M’, $date ) . ‘</span> ‘ . ‘<span class=”d”>’ . date_i18n( ‘j’, $date ) . ‘</span> ‘ . ‘<span class=”y”>’ . date_i18n( ‘Y’, … Read more