How to part DATE and TIME from DATETIME in MySQL

Question

I am storing a  DATETIME field in a Table  Each value looks something like this  2012-09-09 06 57 12   I am using this syntax     date  quot Y-m-d H i s quot     Now my question is  while fetching the data  how can get both date and time separately  using the single MySQL query  Date like 2012-09-09 and time like 06 57 12

User · Accepted Answer

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

User · Answer

per the mysql documentation  the DATE   function will pull the date part of a datetime feild  and TIME   for the time portion  so I would try  select DATE dateTimeField  as Date  TIME dateTimeField  as Time  col2  col3  FROM Table1

User · Answer

For only date use date  Y-m-d     and for only time use date  H i s

User · Answer

Simply  SELECT TIME column name   DATE column name

User · Answer

Try   SELECT DATE  date time field   AS date part  TIME  date time field   AS time part FROM  your table

[php] How to part DATE and TIME from DATETIME in MySQL

SQLFiddle Demo

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to datetime