SQLite Functions

LENGTH(text) # string length
UPPER(text) # convert to uppercase
LOWER(text) # convert to lowercase
SUBSTR(text, start, length) # extract substring
TRIM(text) # remove whitespace
REPLACE(text, old, new) # replace text

ABS(x) # absolute value
ROUND(x, decimals) # round number
MAX(x, y) # maximum value
MIN(x, y) # minimum value
RANDOM() # random integer

DATE('now') # current date
TIME('now') # current time
DATETIME('now') # current datetime
STRFTIME('%Y-%m-%d', 'now') # format date
DATE('now', 'start of month') # first day of month

COUNT(*) # count rows
SUM(column) # sum values
AVG(column) # average
MIN(column) # minimum
MAX(column) # maximum
GROUP_CONCAT(column) # concatenate values

CAST(value AS INTEGER) # convert to integer
CAST(value AS TEXT) # convert to text
CAST(value AS REAL) # convert to real