STRFTIME

1
SELECT STRFTIME(NOW(), '%d-%m-%Y');

1
SELECT STRFTIME(NOW(), '%Y-%m-%d %H:%M:%S');

1
SELECT
2
  order_id,
3
  STRFTIME(order_date, '%d %B %Y') as formatted_date
4
FROM orders;

1
SELECT 'backup_' || STRFTIME(NOW(), '%Y%m%d_%H%M%S') || '.sql' as filename;

1
SELECT
2
  STRFTIME(order_date, '%Y-%m') as year_month,
3
  COUNT(*) as orders,
4
  SUM(amount) as revenue
5
FROM orders
6
GROUP BY STRFTIME(order_date, '%Y-%m')
7
ORDER BY year_month;