SQL
zoo.net
Formatting numbers to two decimal places.
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
SQLite
This rounds up or down
SELECT name, population, ROUND(population/1000000,2), ROUND(population,-6) FROM cia WHERE region='North America'
Specific to SQLite
none
Related links:
FUNCTIONS
Concatenate strings.
Substring: Extracting part of a string.
lower case
Finding a substring in a string
Formatting numbers to two decimal places.
Replace a NULL with a specific value
Conditional values
Get the date and time right now.
Format dates.