SQL Query

[Sqller]

Hello Friends

I have a query like below which is in Oracle syntax.  How do I write this for SQL server?

Your help is highly appreciated.

1. Display the first name and join date of the employees who joined between 2002 and 2005.

SELECT FIRST_NAME, HIRE_DATE FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE, 'YYYY') BETWEEN 2002 AND 2005 ORDER BY HIRE_DATE

[#2]

This board is for things related to Microsoft Learn and Microsoft Certifications. I would recommend reaching out on the SQL Server Community
https://techcommunity.microsoft.com/t5/sql-server/bd-p/SQL_Server

[#3]

oh thanks.