How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]

This doesn’t have anything to do with WordPress, just some PHP code to get what you’re after.

You need to convert MySQL datetime to Unix time by using:

$timestamp = strtotime($psm_mod_datetime);

Then you output this timestamp in the format you desire by using:

echo "Updated: ".date('d F Y', $timestamp);

Related Posts:

  1. $wpdb->get_results returns empty but value exists
  2. $wpdb->get_row() only returns a single row?
  3. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  4. How to use $wpdb to delete in a custom table
  5. Matching database content types to PHP types
  6. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  7. $wpdb->last_error doesn’t show the query on error
  8. Saving custom form data into database
  9. Get data from database table by post_id to get data from second database table
  10. wp-content/db.php : where is this file?
  11. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  12. $wpdb->get_results() returns good result only in first foreach iteration
  13. $wpdb->insert – inserting multiple rows
  14. $wpdb prepared with search term
  15. WPDB->insert with special characters
  16. What does wp_update_post() do that the $wpdb class does not?
  17. Is there a (better) way to access $wpdb results?
  18. $wpdb->prepare not working with update table prefix
  19. How to use prepare to query with variables
  20. Use $wpdb in wordpress theme files
  21. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  22. Problem in creating table through plugin code
  23. I want to update my postcontent with $wpdb
  24. XOR functionality for meta_query
  25. $wpdb->replace / Replace or update primary key
  26. Create an array with a string key from wpdb->get_results
  27. $wpdb – do you have to use foreach even if there will always only be one result?
  28. Replicating the WP_Query ‘s’ param with $wpdb
  29. Need help writing a $wpdb query
  30. get the number of queries made on a page(inside my plugin)
  31. Doing a loop with multiple DBs simultaneoulsy
  32. $wpdb->insert query changes to SHOW COLUMNS query Output
  33. Fixing wpdb->get_results and wpdb->prepare?
  34. How does the WXR file differ from the WPDB?
  35. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  36. Modify the structure of data returned by $wpdb
  37. WPDB If primary key already exists, add +1 to integer field
  38. How to get an array of user roles with or without a specific capability?
  39. What is wrong with this wpdb update?
  40. Programmatically Creating Page using $wpdb and getting 404 error
  41. Constructing a dynamic WPDB query with multiple LIKEs
  42. Problem in inserting row to custom database table
  43. 301 Redirect Code
  44. Counting posts with argument without retrieving the posts
  45. How to display a specific category using a custom Query?
  46. $wpdb->insert inserting only f character in custom table
  47. PHP Fatal Error – $wpdb a non-object?
  48. Why does wpdb->update delete other meta?
  49. Increment integer field in database when WHERE needs to be dynamic [closed]
  50. Getting variable from Database
  51. Create new database through static page code
  52. Custom $wpdb returns unexpected time based results
  53. WordPress “wpdb->update” – Append Text Value
  54. how to connect to another database in wordpress
  55. Need help converting get_user_meta [keys] into own array
  56. Can’t call WPDB inside RSS template
  57. Save sql file after doing insert wpdb
  58. Retrieving posts by their date and category
  59. Perform a function when a user clicks register button
  60. Can I use wpdb to insert query results into a post?
  61. Show all 12 months regardless they have posts
  62. $wpdb->prepare error after WordPress update [duplicate]
  63. Query and get meta as object(stdClass) on wp postmeta table?
  64. How do I query a table?
  65. check that the data exists before sending it to wpdb
  66. How to pass an input value into wpdb->Prepare
  67. no result returns when using $wpdb->get_results with where clause
  68. SQL queries to another wordpress site
  69. PHP | left join avg query give me Array()
  70. update not working using wpdb
  71. get_posts() SQL Injection
  72. og:image functions.php
  73. wpdb replace returning 1 where delete and insert is expected
  74. update_post_meta not working in template_redirect action
  75. WPDB SQL query SELECT from category
  76. How to work with constraints on wordpress user metadata?
  77. $wpdb select returns empty array
  78. Show error messages to a user when database insert fails
  79. Unable to use $wpdb in WordPress
  80. Intermittent problem writing update_user_meta
  81. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  82. Combine posts and postmeta
  83. Get 3 row ID’s via ARRAY_A
  84. Getting record from three wpdb tables
  85. Why is an empty result an error? ( $wpdb->get_row )
  86. get_row returns empty when data exists
  87. wpdb insert working in one function, but not another
  88. wp_commentdata: error in documentation?
  89. Echo only gives me the first part of string
  90. wpdb select from using array as search parameters
  91. wpdb Cannot Access Associative Array Data in a Count Query
  92. esc_sql inserting weird chars to DB
  93. Retriving array size from serialized data
  94. How to update user profile or inputing any data to the wp db from external site?
  95. Can’t get expected result from a wpdb query
  96. Get comments after specific date
  97. selecting row using wpdb which contain special symbols
  98. Query Problem in Clustom Plugin
  99. How does $wpdb->get_var work with offset?
  100. WP Recommended Table Exclusions?