I need to filter posts by values in datetime custom field. So I created date field with “input date and time” option. In database (postmeta table) values stored as unix timestamp and serialized array. But values in unix timestamp format is rounded to date_0:00:00.
Is there only way to get time to unserialize values after getting results of sql query? Or I can force types to store not rounded values as timestamp and filter via sql?
Thanks for plugin, sorry for my poor english:)
- The topic ‘Store time in UNIX timestamp format in database’ is closed to new replies.