SQL
SQL String Functions
Concatenating, trimming, slicing, replacing and searching text - and which of these functions changes name in every dialect.
Functions
String, numeric, date, conversion and conditional functions.
4 notes
Notes
SQL
SQL Numeric Functions
Rounding, truncating, absolute values, modulo and integer division - and the rounding rules that decide whether your invoice totals balance.
SQL
SQL Date and Time Functions
Current date and time, adding and subtracting intervals, differences between dates, extracting parts, and formatting - the least portable corner of SQ...
SQL
CASE, COALESCE, NULLIF and Conversion Functions
Conditional logic inside a query, NULL substitution, safe division and explicit type conversion - four tools that remove most procedural code from SQL...