Find the correct key for game_date_key
and run this once:
global $wpdb;
$posts = $wpdb->get_results("SELECT ID FROM ".$wpdb->prefix."posts" WHERE post_type="post");
foreach ($posts as $post) {
$old_date = get_post_meta($post->ID,'game_date_key',true);
$new_date = date('d/m/Y', strtotime($old_date));
update_post_meta($post->ID,'game_date_key',$new_date,$old_date);
}
(I assume you will have the sense to backup your database first just in case. 🙂
Related Posts:
- Date, Time, and Timezones
- Order by custom field date?
- Order by custom field date with ASC order
- Ordering posts by anniversary using only day and month
- Localized Date Format for Custom Field
- How can I query on the year part of a complete date in a custom field?
- Displaying posts with only upcoming dates according their custom field date value
- Ordering posts by custom field named “date” in backend
- Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
- How show post only from after custom date
- How to query posts by month based on date custom field?
- Order by custom date field
- Group Posts By Custom Meta Value: Date
- WordPress Admin – Automatically Sort Custom Posts by Custom Field Date Value in d-m-Y Fomat
- Thirtieth century date for a post
- Order a query by meta_value and then by post_date
- WordPress archives by custom field and date
- Complex WP_Query Using Post Date And Post Meta
- Checking if field is set before comparing with meta_query in query_posts?
- Display posts where date field matches current month?
- Dynamically update Custom Fields to display new dates
- Best Practice for storing aggregate data by date or other criteria?
- Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
- WP_Query – Order results by meta value
- Add filter menu to admin list of posts (of custom type) to filter posts by custom field values
- getting all values for a custom field key (cross-post)
- How to add a custom field in the advanced menu properties?
- Custom query with orderby meta_value of custom field
- How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
- Using meta query (‘meta_query’) with a search query (‘s’)
- Can I exclude a post by meta key using pre_get_posts function?
- Add validation and error handling when saving custom fields?
- Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
- Show Custom Fields in Quick Edit
- Where are custom field values stored in the database
- Validating Custom Meta Box Values & Required Fields
- Max length of meta_value
- Add custom fields to wp native gallery settings
- How to fix missing custom fields after upgrading to WordPress 4.8.1?
- How to enable custom fields for pages (if not a bad practice)?
- How can I add extra attribute in the ‘Page Attribute’ section in wp-admin for pages?
- Is there a way to set default custom fields when creating a post?
- Custom post meta field effect on the performance on the post
- How to get custom post meta using REST API
- Custom field/meta populated by dropdown of existing posts?
- Difference between meta keys with _ and without _ [duplicate]
- Is there any action filter/hook for validating a custom field before publishing the post?
- Remove Dimension from wp_get_attachment_image
- Orderby meta_value only returns posts that have existing meta_key
- Underscores in custom fields
- What is the index [0] for on post meta fields?
- What is “meta_input” parameter in wp_insert_post() used for?
- Query Posts or Get Posts by custom fields, possible?
- How to enable revisions for post meta data?
- Sortable Custom Columns in User Panel (users.php)?
- Any way to add custom options to Gallery Settings?
- The “_encloseme” Meta-Key Conundrum
- ORDER BY custom field value
- Individual Widgets per Page
- Add subtitle to Woocommerce product title
- Best way to programmatically remove a category/term from a post
- Importing data for advanced custom fields plugin?
- Gutenberg add a custom metabox to default blocks
- SQL Query to copy value of a meta_key into another meta_key
- ‘Preview Changes’ for custom meta boxes?
- Adding a custom field to the site identity menu
- Using TinyMce with textareas in meta boxes on custom post types
- Filter WP_Query for posts having a certain meta-value
- How to correctly call custom field dates into a posts_where filter using SQL statements
- Using get_post_meta with new_to_publish
- Is there a way to get protected meta fields through any of the available built-in WordPress APIs? (xmlrpc, wp-json)
- Add a Jquery Datepicker to custom field in post edit
- add meta box – custom field : which to choose?
- Preserving line breaks when saving and displaying custom fields data
- How to return Meta data from the REST API?
- Advanced Custom Fields – Get custom fields from parent page
- Can I query custom meta data through WP_Query
- Add custom field to the archive page?
- Saving custom data for each user
- Is it safe to store a user setting you don’t want the user to ever modify as a user option?
- Tabindex on text input immediately after WordPress title input
- Including custom fields in search?
- Add custom fields to search
- SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
- Attaching Metadata to a Taxonomy Item
- Add metabox to document tab in gutenberg
- How to display all custom fields associated with a post?
- How to add add_meta_box to specific Page Template?
- How to rename a custom field?
- Apply the_content filter to a custom field with multiple values
- Filter post listing by meta value which is a date
- Extra profile field as select box?
- Matching Serialized Arrays with meta_query
- How can I make wp-pagenavi work on a custom query built upon a form submission? [closed]
- Custom field metabox not showing in back-end
- Meta Query with AND & OR?
- Pre-filling custom fields on New Post
- Having different sidebar content for MANY pages?
- So much data in postmeta
- Custom search: by post data and post metadata?