The WordPress current_time() returns the current time in the format specified in the first parameter. In your example code, this is the mysql value. The second parameter represents a timezone option. The default returns the local time for the timezone specified on the site’s Settings > General page, or GMT depending on the value supplied … Read more
Most likely, the ‘at’ is coming from the value of $comment->comment_date. If that is the case, and since we have to do with string, you could pass it from str_replace first, in order to remove the ‘ at’, like: function my_change_comment_date_format( $date, $date_format, $comment ) { return date( ‘d M Y’, strtotime( str_replace(” at”, “”, … Read more
For this to work reliably, the date format in the database should be yyyy-mm-dd. Comparison type should be DATE or NUMERIC. If you take the date of 25-04-2012 in present format and compare it numerically to the date 26-04-1986, you can see what the issue will be: 25042012 < 26041986 ALso- if you’re doing these … Read more
The following query retrieves the oldest post of a specified user/author: $user_id = 42; // or whatever it is $args = array( ‘posts_per_page’ => 1, ‘post_status’ => ‘publish’, ‘author’ => $user_id, ‘orderby’ => ‘date’, ‘order’ => ‘ASC’, ); $first_post = new WP_Query($args); if ($first_post->have_posts()) { $first_post->the_post(); // Now you can use `the_title();` etc. wp_reset_postdata(); } … Read more
Saving the date in post meta is a slightly more sane approach, the post_date column was not designed with your use case in mind. You may get weird results with dates before the Unix epoch (January 1, 1970). Then it’s just a simple meta_query to load posts between dates, no filter necessary. $start=”1900-01-01″; $end = … Read more
Just use the_date(), it has this as a built-in feature. See the dev docs for more info.
Depends what you are getting back from the ‘date_event’ post-meta field. That’s probably the culprit here — if it’s an actual date with a month and day, it’s not going to match what you are getting from date(‘Y’), which is just going to be ‘2018’. You can check the value in ‘date_event’ on any of … Read more
The handy thing about how ACF stores dates as YYYYMMDD is you can treat them like integers and get a similar level of functionality as if you were using “true” dates. For example, to get all dates after 1st Jan 2011, use > 20110101. Those before June 1st 2012? < 20120601. And for your case, … Read more
Use get_query_var() to get the date parts: $year = get_query_var(‘year’); $monthnum = get_query_var(‘monthnum’); $day = get_query_var(‘day’); In wp_title() a call to get_query_var(‘m’) is used for the month too, but I got always just a 0 as value even on an URL like /2008/09/05/. If you want to print the month name, use: $GLOBALS[‘wp_locale’]->get_month($monthnum); The month … Read more
I solved the same problem like this First you store each posts in another array called $events_by_date with date as the index. If another event post falls in the same date you put that post under the same index. Please comment if you need further explanation. <?php //setup your wp_query parmeters to make the query … Read more