DATE_PART

1
SELECT 
2
  DATE_PART(year, TIMESTAMP 2024-06-15 14:30:00) AS year,
3
  DATE_PART(month, TIMESTAMP 2024-06-15 14:30:00) AS month,
4
  DATE_PART(day, TIMESTAMP 2024-06-15 14:30:00) AS day;

1
SELECT 
2
  DATE_PART(dow, CURRENT_DATE) AS day_of_week,
3
  DATE_PART(doy, CURRENT_DATE) AS day_of_year;

1
SELECT 
2
  DATE_PART(quarter, order_date) AS quarter,
3
  SUM(total) AS revenue
4
FROM orders
5
WHERE DATE_PART(year, order_date) = 2024
6
GROUP BY quarter;