MulaiMulai sekarang secara gratis

Conversion functions

As a final request, eSymphony has asked you to help them get some insight into their hiring over time. They want to know for all years in the database, the total number of employees hired each month. The resulting date should be formatted as follows: 2019-12.

To achieve this, you need to make use of conversion functions to convert the HireDate from the Employee table to a suitable format.

Latihan ini adalah bagian dari kursus

Introduction to Oracle SQL

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

-- Select the converted date from the Employee table
SELECT ___(___, '___') AS YearMonth
___
Edit dan Jalankan Kode