Post meta is stored in the wp_postmeta
table. Values are stored as longtext, not as dates or integers.
So your safest bet is to store these datetime fields as Unix timestamps. Then you can sort them using a meta query.
Related Posts:
- Custom Post Type Data in Sidebar widgets?
- How to filter custom posts by tags and custom fields?
- How to order adjacent posts (prev / next) by custom field value?
- Hide custom post type field from author?
- Many to Many Relationship between Two Custom Post Types
- Sorting a query by custom field date
- echo value from ‘select’ field type into page template using cmb2?
- wordpress plugin error handling
- Creating Photo Gallery System with Custom Post Type
- Set post title from two meta fields
- How to sort CPT by custom meta value (date), and return posts month by month
- How to solve suspected memory issue in custom WordPress loop?
- Trying to save custom post type from frontend partially working
- Custom Taxonomy order by Custom Field
- Comparing timestamps in meta query doesn’t work
- Display two post types ordered by two custom fields
- Is there any performance consideration when using Custom Post Types?
- Custom Post Type Navigation on Custom Field
- how to interconnect custom post types?
- WP All Import – Using Xpath to set a select value
- Adding dropdown select meta box to custom post type – seems restAPI is interfering
- Automatically update custom field in all posts of a custom post type
- search also in taxonomy, tags and custom fields
- Add field to all custom post types
- Filter custom posts using auto populated dropdown selectors
- Querying Two Custom Post Types with OR Not Working
- How can I get the number of custom post type posts that have a specific attachment image set?
- Bulk Update Custom Fields for Custom Post Types
- Add custom field to Posts and sort by it
- Two Custom Post Types Many to Many Relationship
- Including metaboxes from custom post types in global search — continued
- Show image gallery from a custom field
- Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
- filter custom post in rest api with custom function
- Custom Fields for Custom Post [closed]
- Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
- Adding Page Templates to post but it ignored it
- Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
- Is there any way to add a “custom field” to the CPT archive page?
- How to let users choose where to search for posts?
- don’t publish custom post type post if a meta data field isn’t valid
- WebP Fallback for Inline Background Image in Style Attribute
- How can meta boxes be added to “unknown” custom posts?
- Custom “radio button meta box” not saving correctly
- Check if post with same meta value exists
- Custom posts type for individual pages?
- custom post data – how to
- Get Post Terms of Current Post (selected taxonomy term) – How to get only the taxonomy value and not “Array ( [0] => taxonomy term )” in the frontend?
- WP Query ‘posts_per_page’
- Custom Post Type Metadata Not Saving
- Editor / Add Media: Is it possible to only allow galleries?
- What do the numbers mean at the end of add_action(‘save_post’)…?
- A meta box (in a custom post type) with two different type of fields
- Many to many to many custom post relationships
- copy images from custom field to another custom field
- Custom Query: If One Post Object Field Value Is The Same As Another
- How to migrate Custom Field Template to a WordPress Multisite
- Sum and count of custom field values
- Reusable metabox backend and frontend
- Cannot obtain custom meta information
- How to use a specific custom field in a custom post type as slug
- How do I show my containing my custom field ONLY if there is a set value on that custom field? [closed]
- How to hide a custom field from admin?
- How to import database table as custom post type and custom fields?
- Adding an extra parameter [string] to my posts’ permalink?
- Add Extra Category Field to CPT Categories
- Cache issue with WP_Query and custom field filtering
- Fill custom fields when saving custom post types
- Empty meta-box returns publishdate if no value is set?
- Custom Post Type Meta Box Text Input Field Won’t Save When Blank
- Use Gravity Forms and a Shopping Cart for output to Freshbooks for an Estimate [closed]
- Alike Shortcode using in Custom Shortcode
- wp_set_object_terms creates taxonomies but does not add custom posts to it
- Why this didn’t work if i use get_the_ID(), but works if i pass the numeric id
- What is the correct way that when creating a custom post type assign values to custom fields created with pods framework?
- Custom Metabox Info Not Saving
- Post Filtered by Custom Field Value
- Autofill advanced custom field with user data
- Advanced search form with multiple custom fields
- Meta_Query refuses to return results
- Multi Photo Upload with Caption on Front End for Custom Post Type
- Search facility with directories
- How to make a shortcode for my WP_Query Loop? [duplicate]
- WordPress is giving a warning but my code is working fine
- Query events post type after current date and timezone
- Avoid another meta box in my custom post type
- Can’t pick up a field created with Advanced Custom Fields
- Pre_get_posts comparison with custom field doesn’t work
- How to stop wp_query searching pages as well as the specified CPT
- Post content is cleared when updating
- Unable to get the upcoming events for custom post
- Custom field totals
- custom taxonomies are not showing up in get_taxonomies
- How can i display on front page a movie that is atached in a post type
- Types plugin isn’t compatible with my custom post type
- Show Posts in Vertical Tabs with Scrollbar
- How do I filter a custom post type loop by a field?
- Custom Post type as Taxonomy
- Display div based on Group metabox selection [closed]
- Custom Sort Order for Custom Post Type Taxonomy