SQL
Formatters
Integers:  
```sql
SELECT printf('%d + %d = %d', 3, 5, 3 + 5); -- 3 + 5 = 8
```  
Booleans:  
```sql
SELECT printf('%s != %s', true, false); -- true != false
```  
Format datetime values:  
```sql
SELECT printf('%s', DATE '1992-01-01'); -- 1992-01-01
SELECT printf('%s', TIME '12:01:00'); -- 12:01:00
SELECT printf('%s', TIMESTAMP '1992-01-01 12:01:00'); -- 1992-01-01 12:01:00
```  
Format BLOB:  
```sql
SELECT printf('%s', BLOB '\x00hello'); -- \x00hello
```  
Pad integers with 0s:  
```sql
SELECT printf('%04d', 33); -- 0033
```  
Create timestamps from integers:  
```sql
SELECT printf('%02d:%02d:%02d %s', 12, 3, 16, 'AM'); -- 12:03:16 AM
```  
Convert to hexadecimal:  
```sql
SELECT printf('%x', 123_456_789); -- 75bcd15
```  
Convert to binary:  
```sql
SELECT printf('%b', 123_456_789); -- 111010110111100110100010101
```