Date conversion in mysql column

MySQL DATE_FORMAT() formats a date as specified in the argument. A list of format specifiers given bellow may be used to format a date. The ‘%’ is required before the format specifier characters.

Syntax:

DATE_FORMAT(date,format)

Similar codes

8 votes177 views1 answer
Oracle tablespace datafile max size
SQL
0 vote164 views1 answer
Postgresql using reserved word as column name
SQL
0 vote174 views1 answer
Including parameters in OPENQUERY
SQL
0 vote166 views1 answer
Check for directory in bash
SQL
0 vote142 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote157 views1 answer
How to write if case in select query in select statement
SQL
0 vote175 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote194 views1 answer
Postgressql uuid
SQL
4 votes208 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote126 views5 answers
Spring boot sql logging
SQL