Mysql number format

Mysql format date

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

Source: mysqltutorial.org

Mysql text to decimal

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName

Source: stackoverflow.com

Mysql number format

FORMAT( number, decimal_places )

Source: techonthenet.com

Similar codes

1 vote217 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote232 views1 answer
Media sql
SQL
0 vote236 views2 answers
Update all columns in one update
SQL
-1 vote289 views5 answers
Left join sql
SQL
3 votes223 views1 answer
How to remove characters from string in mysql
SQL
0 vote224 views1 answer
Sql developer format sql
SQL
2 votes257 views1 answer
Metasploit start postgresql
SQL
0 vote222 views1 answer
Json_remove mysql
SQL
8 votes235 views2 answers
Alert table name mysql
SQL
0 vote219 views1 answer
How to remove default in mysql
SQL