Query to convert from datetime to date mysql

Question

I am trying to get the date portion of a datetime field  I know I can get it with date format  but that returns a string or  varchar  field  How can I convert the result to date and not as varchar   This is my query  returning the varchar    Select Date Format orders date purchased   m  d  Y    As Date     I tried several combinations from this question  but could not make it to work    mysql query - format date on output   Any help is appreciated

User · Accepted Answer

Try to cast it as a DATE  SELECT CAST orders date purchased AS DATE  AS DATE PURCHASED

User · Answer

Use the DATE function   SELECT DATE orders date purchased  AS date

User · Answer

I see the many types of uses  but I find this layout more useful as a reference tool   SELECT DATE FORMAT  2004-01-20     Y- m-01

User · Answer

syntax of date format   SELECT date format date born    m  d  Y    as my date FROM date tbl        W  D  M  Y  T     - gt  Wednesday 5th May 2004 23 56 25       a  b  e  Y  H  i  - gt  Wed May 5 2004 23 56       m  d  Y  T        - gt  05 05 2004 23 56 25       d  m  Y           - gt  05 05 2004       m- d- y           - gt  04-08-13

User · Answer

Either Cybernate or OMG Ponies solution will work  The fundamental problem is that the DATE FORMAT   function returns a string  not a date  When you wrote    Select Date Format orders date purchased   m  d  Y    As Date    I think you were essentially asking MySQL to try to format the values in date purchased according to that format string  and instead of calling that column date purchased  call it   Date   But that column would no longer contain a date  it would contain a string   Because Date Format   returns a string  not a date     I don t think that s what you wanted to do  but that s what you were doing   Don t confuse how a value looks with what the value is

[sql] Query to convert from datetime to date mysql

Examples related to sql

Examples related to mysql

Examples related to datetime

Examples related to date