DATE_PART

1
SELECT
2
  DATE_PART('year', order_date) as year,
3
  DATE_PART('month', order_date) as month,
4
  DATE_PART('day', order_date) as day
5
FROM orders
6
LIMIT 5;

1
SELECT
2
  DATE_PART('year', sale_date) as year,
3
  DATE_PART('quarter', sale_date) as quarter,
4
  SUM(amount) as quarterly_sales
5
FROM sales
6
GROUP BY 1, 2
7
ORDER BY 1, 2;

1
SELECT
2
  EXTRACT(MONTH FROM CURRENT_DATE) as extract_month,
3
  DATE_PART('month', CURRENT_DATE) as datepart_month;