SQL DATEPART() | How SQL DATEPART() work with Query Examples
However, datepart() function works in SQL Server, Oracle, and Azure SQL databases only. For other database management servers such as PostgreSQL and MYSQL, we can use functions like EXTRACT(). You may refer to