DATE_TRUNC

Problem

The HR team generates monthly reports. Instead of looking at exact hire dates, they want to group everyone hired in the same month together by forcing all hire dates to the 1st of that month. Truncate the hire_date of each employee to the month. Return first_name and the truncated date.

Database Schema

Table: employees

• employee_id (INT): Unique identifier for the employee.
• first_name (VARCHAR): First name of the employee.
• last_name (VARCHAR): Last name of the employee.
• salary (INT): Employee's salary.
• department_id (INT): Foreign key referencing the department.
• manager_id (INT): Foreign key referencing the manager (another employee).
• hire_date (DATE): Date the employee was hired.

Table: departments

• department_id (INT): Unique identifier for the department.
• department_name (VARCHAR): Name of the department.

Try It

Hint

Solution