EXTRACT

1
SELECT
2
  order_date,
3
  EXTRACT(YEAR FROM order_date) as year,
4
  EXTRACT(MONTH FROM order_date) as month,
5
  EXTRACT(DAY FROM order_date) as day
6
FROM orders;

1
SELECT *
2
FROM sales
3
WHERE EXTRACT(DAYOFWEEK FROM sale_date) IN (0, 6);

1
SELECT
2
  EXTRACT(YEAR FROM order_date) as year,
3
  EXTRACT(QUARTER FROM order_date) as quarter,
4
  SUM(amount) as total_revenue
5
FROM orders
6
GROUP BY 1, 2
7
ORDER BY 1, 2;

1
SELECT
2
  order_date,
3
  YEAR(order_date) as year,
4
  MONTH(order_date) as month,
5
  DAY(order_date) as day,
6
  HOUR(order_timestamp) as hour
7
FROM orders;