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 vote334 views1 answer
Postgres list tables and row counts
SQL
0 vote283 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote306 views1 answer
Sql developer search all packages for text
SQL
0 vote320 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote334 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote312 views1 answer
Insert ip address in mysql
SQL
0 vote329 views1 answer
Amount of entries in a table psql
SQL
0 vote295 views1 answer
In mysql workbench contnent not feching
SQL
13 votes321 views2 answers
Oracle select into and inner join
SQL
0 vote309 views1 answer
Ceil upto 2 decimal place mysql
SQL