The filter on posts_orderby should return a string that does not begin with ORDER BY, WordPress will add that itself. By default WordPress will filter by post_date. If you don’t want that, you should overwrite the order clause, not append to it. So your filter should look like this: function filter_orderby( $orderby ) { global … Read more
From the comments in the WP_Post class in wp-includes/post.php: You can set the post date manually, by setting the values for ‘post_date’ and ‘post_date_gmt’ keys. So if you’re adding a post programmatically, and you want a date attached, you should set both keys. (If you leave them blank, WordPress will use the appropriate current date … Read more
Please try this way: Change date, the_date, the_time to get_date, get_the_date, get_the_time. function KhmerNumDate ($text) { $text = str_replace(‘1’, ‘១’, $text); $text = str_replace(‘2’, ‘២’, $text); $text = str_replace(‘3’, ‘៣’, $text); $text = str_replace(‘4’, ‘៤’, $text); $text = str_replace(‘5’, ‘៥’, $text); $text = str_replace(‘6’, ‘៦’, $text); $text = str_replace(‘7’, ‘៧’, $text); $text = str_replace(‘8’, ‘៨’, … Read more
You would just need to format the time that is returned by current_time() with the php date() function like this: $my_time = date(‘G’, current_time(‘timestamp’)); The param ‘G’ tells the function you just want to have the hour part (0 to 23) of the date. Have a look here: http://www.php.net/manual/en/function.date.php
The date/time related field types for CMB2 store all their values as Unix timestamps in the database with the exception of text_datetime_timestamp_timezone which stores it’s value as a serialized DateTime object. text_date_timestamp Date Picker (UNIX timestamp) text_datetime_timestamp Text Date/Time Picker Combo (UNIX timestamp) text_datetime_timestamp_timezone Text Date/Time Picker/Time zone Combo (serialized DateTime object) See: https://github.com/WebDevStudios/CMB2/wiki/Field-Types What … Read more
If we want to work with php’s datetime features and timezone objects AND handle sites that use a gmt_offset, sadly it does require some trickery. I have not found a better way to do it than this: Check for timezone string first – got one – great! Else Check for gmt offset, then try to … Read more
Try below code. echo get_the_date(__(‘M d’)); Output: Feb 09 echo get_the_date(__(‘M d, Y’)); Output: Feb 09, 2017
As mmm said, wp stores all dates× in gmt, but will show times as per the setting timezone. So you can cgange the timezone without the history needing to be updated. I prefer to use the php datetime when working with time. Gives better control and flexibility, eg if you want to show events in … Read more
Regarding comments- what about the case where a comment older than 90 days has child replies younger than 90 days? for comment and pingback status, this should do it: UPDATE wp_posts SET comment_status=”closed”, ping_status=”closed” WHERE post_date < DATE_SUB(NOW(), INTERVAL 3 MONTH) AND post_status=”publish”;
You could easily do this using mysql: DELETE FROM wp_comments WHERE comment_date < DATE_ADD(CURDATE(), INTERVAL -6 MONTH)