how to remove time from datetime

The field DATE in the database has the following format:

2012-11-12 00:00:00

I would like to remove the time from the date and return the date like this:

11/12/2012

Related Posts:

  1. ORA-01843 not a valid month- Comparing Dates
  2. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  3. How do I format date and time on ssrs report?
  4. Query to convert from datetime to date mysql
  5. How to change post published date to today date with SQL
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  8. SQL WITH clause example [duplicate]
  9. The wait operation timed out. ASP
  10. Conversion failed when converting date and/or time from character string while inserting datetime
  11. how to fix oracle ORA-01722 invalid number error
  12. SQL query to select dates between two dates
  13. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. NOT IN vs NOT EXISTS
  15. Must declare the scalar variable
  16. ORA-00979 not a group by expression
  17. How can I do a FULL OUTER JOIN in MySQL?
  18. MySQL query String contains
  19. How do I escape a single quote in SQL Server?
  20. Oracle error : ORA-00905: Missing keyword
  21. How do I import an SQL file using the command line in MySQL?
  22. mysql Foreign key constraint is incorrectly formed error
  23. Can a foreign key be NULL and/or duplicate?
  24. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  25. How do composite indexes work?
  26. Query comparing dates in SQL
  27. MySQL “WITH” clause
  28. What is the difference between JOIN and UNION?
  29. MySQL Multiple Joins in one query?
  30. Error Code: 2013. Lost connection to MySQL server during query
  31. “CASE” statement within “WHERE” clause in SQL Server 2008
  32. SQL join on multiple columns in same tables
  33. ORA-00972 identifier is too long alias column name
  34. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  35. Sql query – getting rid of hard-coded values
  36. ORA-00918: column ambiguously defined in SELECT *
  37. Combining “LIKE” and “IN” for SQL Server
  38. How To Run A Github Repository?
  39. SQL Switch/Case in ‘where’ clause
  40. How to run a SQL query on an Excel table?
  41. Algebra Relational sql GROUP BY SORT BY ORDER BY
  42. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  43. Oracle “Partition By” Keyword
  44. What is the equivalent of ‘describe table’ in SQL Server?
  45. Add a column with a default value to an existing table in SQL Server
  46. Remote table-Valued Function Calls are not allowed
  47. The backend version is not supported to design database diagrams or tables
  48. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  49. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  50. Difference between View and table in sql
  51. Using group by on multiple columns
  52. What is the purpose of using WHERE 1=1 in SQL statements?
  53. Exclude a column using SELECT * [except columnA] FROM tableA?
  54. How do you force mysql LIKE to be case sensitive?
  55. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  56. What is the difference between a stored procedure and a view?
  57. Bulk load data conversion error (truncation)
  58. Insert into a MySQL table or update if exists
  59. Convert timestamp to date in Oracle SQL
  60. How to order by with union in SQL?
  61. Update statement with inner join on Oracle
  62. Can I use multiple “with”?
  63. PostgreSQL create table if not exists
  64. Join vs. sub-query
  65. Alternative to except in MySQL
  66. DATEDIFF function in Oracle
  67. GROUP BY and COUNT using ActiveRecord
  68. MySQL – Get row number on select
  69. What does * mean in sql?
  70. How to truncate the text returned for a column in a MySQL query
  71. INSERT VALUES WHERE NOT EXISTS
  72. Using union and order by clause in mysql
  73. Difference between `load data inpath ` and `location` in hive?
  74. How to implement LIMIT with SQL Server? [duplicate]
  75. What’s the best way to dedupe a table?
  76. How To Write An Inner Join With WP Query
  77. How do I escape a table name or column name in SQL? esc_sql doesn’t do this
  78. Update user_login, user_nicename, and display_name
  79. Change sticky status of posts from phpMyAdmin
  80. Fetch all Posts where logged in user has commented
  81. Needing to move content from postmeta to posts in sql [closed]
  82. How to import a Typo3 database to a wordpress site?
  83. What does the $posts_join filter join to?
  84. Clean up very big and very dirty database
  85. How to delete ALL comments from certain category in WordPress database?
  86. How can I convert everything from category X to have post format Link
  87. Bulk delete WordPress Post and all metadata, etc using SQL query
  88. What steps do I need to take to install a local copy of a live website?
  89. Reset post IDs with all post meta
  90. How to Add or Change Post Title
  91. Why does DROP TABLE-ing the `wp_options` reset my user session?
  92. How to refactor DB queries for better TTFB in WordPress?
  93. query sql-table and change entities
  94. Duplicate WP Migration affecting site on separate domain?
  95. Analog category_and (WP) in sql query
  96. Backtick (MySQL norm) added to SQL Server Query causing error
  97. SQL query to check whether a meta key is set or not for a post in post_meta table
  98. How to get the sum of each post with the same date
  99. How to dump a Microsoft SQL Server database to a SQL script?
  100. Deleting the MySQL database

Leave a Comment

tech