SELECT
  hire_date,
  EXTRACT(YEAR FROM hire_date) AS year,
  EXTRACT(MONTH FROM hire_date) AS month,
  EXTRACT(DAY FROM hire_date) AS day,
  EXTRACT(DOW FROM hire_date) AS day_of_week,
  EXTRACT(DOY FROM hire_date) AS day_of_year,
  EXTRACT(QUARTER FROM hire_date) AS quarter,
  EXTRACT(WEEK FROM hire_date) AS week_number
FROM employees;