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

2 votes345 views1 answer
Match in sql server
SQL
0 vote381 views1 answer
How to make case insensitive in sql
SQL
36 votes382 views3 answers
Add column in mysq
SQL
0 vote369 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
21 votes405 views6 answers
Update sql
SQL
0 vote377 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote360 views1 answer
Tsql generate rows
SQL
2 votes337 views1 answer
Install sqlite npm
SQL
0 vote362 views2 answers
Demmarrer un service mysql teminal cmd
SQL
3 votes348 views2 answers
How to View column names of a table in SQL
SQL