How to separate DATE and TIME from DATETIME in MySQL?

by

You can achieve that using DATE_FORMAT() (click the link for more other formats)

SELECT DATE_FORMAT(colName, '%Y-%m-%d') DATEONLY, 
       DATE_FORMAT(colName,'%H:%i:%s') TIMEONLY

SQLFiddle Demo

More Related Contents:

  1. How to convert ISO8601 to Date format in php
  2. PHP DateTime supported formats
  3. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  4. Using PHP data in MySQL [closed]
  5. Checking the availability of rooms
  6. How to properly set up a PDO connection
  7. Commands out of sync; you can’t run this command now
  8. SELECT COUNT(*) AS count – How to use this count
  9. Get table column names in MySQL?
  10. How to resolve ambiguous column names when retrieving results?
  11. Loading .sql files from within PHP
  12. selecting unique values from a column
  13. Use bound parameter multiple times
  14. Object of class DateTime could not be converted to string
  15. MySQL “NOT IN” query 3 tables
  16. Create a dynamic mysql query using php variables
  17. PHP: multiple SQL queries in one mysql_query statement
  18. Why does this return Resource id #2? [duplicate]
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. Date in a URL dd/mm/yyyy
  21. How to generate unique id in MySQL?
  22. MySql PHP select count of distinct values from comma separated data (tags)
  23. How to SELECT DEFAULT value of a field
  24. adding 30 minutes to datetime php/mysql
  25. How to check if a value already exists to avoid duplicates?
  26. UNION syntax in Cakephp
  27. MYSQL select a piece of a string and order by that piece
  28. How do i search from serialize field in mysql database?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment