Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table

“MySQL retrieves and displays DATETIME values in ‘YYYY-MM-DD HH:MM:SS’ format.” This is from mysql site. You can store only this type, but you can use one of the many time format functions to change it, when you need to display it.

Mysql Time and Date functions

For example, one of those functions is the DATE_FORMAT, which can be used like so:

SELECT DATE_FORMAT(column_name, '%m/%d/%Y %H:%i') FROM tablename

Related Posts:

  1. How do I import an SQL file using the command line in MySQL?
  2. Should I use the datetime or timestamp data type in MySQL?
  3. MySQL date formats – difficulty Inserting a date
  4. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  5. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  6. Cannot add or update a child row: a foreign key constraint fails
  7. How to make MySQL table primary key auto increment with some prefix
  8. Cannot delete or update a parent row: a foreign key constraint fails
  9. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  10. Rename a column in MySQL
  11. Not unique table/alias
  12. Install mysql-python (Windows)
  13. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  14. Select from multiple tables without a join?
  15. SQL Query Where Field DOES NOT Contain $x
  16. How to join two tables by multiple columns in SQL?
  17. How to get size of mysql database?
  18. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  19. Mysql command not found in OS X 10.7
  20. MySQL – UPDATE query based on SELECT Query
  21. grabbing first row in a mysql query only
  22. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  23. Order a MySQL table by two columns
  24. MySQL AS keyword
  25. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  26. How do I change the data type for a column in MySQL?
  27. Generating a random & unique 8 character string using MySQL
  28. Unknown Column In Where Clause
  29. Cannot connect to Database server (mysql workbench)
  30. Query to convert from datetime to date mysql
  31. mysqld: Can’t change dir to data. Server doesn’t start
  32. How to solve “Error: MySQL shutdown unexpectedly”?
  33. Can’t create test file lower test start server mysql
  34. MySQL delete multiple rows in one query conditions unique to each row
  35. Can you do a For Each Row loop using MySQL?
  36. Drop all databases in MySQL
  37. How to properly create composite primary keys – MYSQL
  38. MySQL – count total number of rows in php
  39. How to get the count of each distinct value in a column?
  40. Data is not constantly loading from custom wordpress table
  41. How to run WordPress across 2 VMs for high availability
  42. Mysqldump add drop table?
  43. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  44. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  45. SQL query to update post_date (one post = one single date & time)
  46. #1115 – Unknown character set: ‘utf8mb4’
  47. WordPress Deadlock Error
  48. How to do a MySQL dump from production site without using a search and replace script for local development?
  49. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  50. How to bulk edit canonical url’s in SQL?
  51. Concurrent / simultaneous MySQL connections
  52. How to check for empty and not a failure
  53. What is the most secure way to set up the MySQL user in WPMU?
  54. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  55. Keeping database within limits, please help!
  56. Best settings for MySQL to speed up site? [closed]
  57. HTML Entities in Post Title
  58. Can’t find my wordpress DB in phpmyadmin
  59. Deprecated: mysql_connect():
  60. $wpdb select all meta for each post
  61. Regarding “Insert query error” in wordpress
  62. Calculate average crossing post categories
  63. WordPress plugin overloading with tmp tables
  64. Replacing link URL ending strings via MySQL
  65. Many slow queries post_type = ‘attachment’;
  66. SQL command to convert all tags in lowercase?
  67. Problem with admin login after deployment
  68. Find out how many times the user has logged in
  69. Is it possible to create a WordPress table using array and loop?
  70. Can’t run database query
  71. How to stop $wpdb from prepending database name
  72. Match tag names with form titles
  73. Error missing MySQL extension
  74. Getting Error Trying to Create Table
  75. Best approach for a custom database filling in WP custom post types
  76. Why doesn’t custom mysql query return results? Is syntax correct?
  77. List users with the most posts in the last 30 days
  78. Insert two row in wordpress database
  79. SQL statement using placeholder is not returning results
  80. How to Bulk find and replace MySQL for post image url
  81. Wpdb query with dynamic table name
  82. Regular XML-RPC timeouts
  83. update multiple rows in mysqli table base on two values
  84. I want to share local developement and staging DB — Is this very smart or very stupid?
  85. How can I verify WordPress nonce from the following code?
  86. How to write in MySQL more characters in user_nicename
  87. $wpdb->get_var not returning count
  88. Custom user query – orderby meta_key (that may not exist)
  89. How to get Attachments(image) with specific width\height ratio
  90. What is the cron doing?
  91. Apache Redirect based on WordPress permissions
  92. SQL error on restoring database
  93. MySQL database gives blank page (white screen of death)
  94. Datatabase error: Commands out of sync
  95. why is $wpdb->update() causing a DB error from within wp_set_password()
  96. Global MySQL replacing of text patterns/matches
  97. WP_Query with LIKE returns strange query
  98. InnoDB: Error: log file ./ib_logfile0 is of different size
  99. Postgres equivalent to MySQL’s \G?
  100. How can I show mysql locks?

Leave a Comment