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 vote261 views1 answer
Size of all tables in a schema oracle
SQL
0 vote269 views1 answer
Left join vs inner join performance
SQL
8 votes219 views2 answers
Alter column name in mssql
SQL
0 vote243 views1 answer
Alasql delete column
SQL
0 vote266 views1 answer
Create a plsql object
SQL
0 vote253 views1 answer
Postgresql import a database of gzip
SQL
0 vote247 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
4 votes250 views4 answers
Update select mysql
SQL
2 votes259 views1 answer
Mariadb JSON_EXTRACT
SQL
5 votes286 views1 answer
Oracle get ddl
SQL