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

0 vote112 views1 answer
Postgresql delete multiple rows
SQL
1 vote124 views1 answer
How to select random rows from a table
SQL
0 vote124 views1 answer
Connect postgresql using a connection string
SQL
2 votes113 views1 answer
Ssh mysql port forwarding
SQL
10 votes125 views2 answers
Forgot my mysql password mac
SQL
0 vote120 views1 answer
Print mysql
SQL
0 vote118 views2 answers
How to know the character set of an oracle databes
SQL
0 vote117 views1 answer
View to table
SQL
5 votes123 views1 answer
Mysql where one year ago
SQL
0 vote117 views1 answer
Sql date d'aujourd'hui
SQL