Search code examples
mysqlsqlstr-to-date

Mysql str_to_date shows null instead of formatted date

I am facing a silly problem while converting datetime column into y-m-d format.

I am running following query :

SELECT STR_TO_DATE(dateadded, '%y-%m-%d') FROM my_table

Note : The dateadded column is a type of datetime.

Whenever I am running above query it always shows (NULL).

Can somebody solve this issue as this is irritating me ?

Solution

  • Since your column is of datetime type rather than string type you should use DATE_FORMAT function as below:

    SELECT DATE_FORMAT(dateadded, '%y-%m-%d') 
FROM my_table